Concepts and Architecture Question:
Download Questions PDF

Tell me what does a Control file Contain?

Answer:

The controlfile contains :
1. Name and Location of Datafiles, Redo Logfiles.
2. Timestamp of Database Creation.
3. Current log sequence number is recorded when log switches are occur.
4. Checkpoint information is recorded as checkpoints are made.
5. Database identifier is recorded when the database is created.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what are the Referential actions supported by FOREIGN KEY integrity constraint?What is a Data Dictionary in Oracle?