Concepts and Architecture Question: Download Oracle Architecture and Concepts 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.
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.
| Previous Question | Next Question |
| Explain what are the Referential actions supported by FOREIGN KEY integrity constraint? | What is a Data Dictionary in Oracle? |