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