Concepts and Architecture Question:
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.
Previous Question | Next Question |
Explain what is meant by snapshot error? | Tell us what is an Integrity Constrains? |