What do you understand by a control file?

devquora
devquora

Posted On: Feb 22, 2018

 

  • It is a twofold file that keeps the record of the bodily structure of the database
  • It holds the information regarding checkpoint, database name, timestamp, number of log files and their location
  • It is easy to find the control file location by using the CONTROL_FILE parameter as it holds its information.
  • It is better to make multiple numbers of the control file to avoid the problem of the corrupted file.
  • With the help of the control file, you can withdraw the failure's risk.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle DBA Interview Questions

    What do you understand by the Oracle?

    Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

    Oracle DBA Interview Questions

    What do you mean by Oracle Database?

    Oracle has the main theme of storing, creating and managing the database...

    Oracle DBA Interview Questions

    What do you mean by Oracle DBA and what is its role?

    DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...