Concepts and Architecture Question:
Download Questions PDF

Tell us what is the use of Control File?

Answer:

Controlfile contains the information about the database like names and locations of datafiles, name of the database, database creation timestamp and apart from this the SCN are also reported into control during the database operation. Especially during the database startup the controlfile is used to gather the information about the database and while opening the database the information in the controlfile is validated to check for the consistency of the database.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what is meant by snapshot error?Tell us what is an Integrity Constrains?