This preview shows page 1. Sign up to view the full content.
Unformatted text preview: a text file.
B. It is a fixed size.
C. It should be multiplexed.
D. It is required to start the instance.
E. It must be updated at every log switch.
Answer: C, E
Answers C and E are correct. The control file should be multiplexed and it must be updated at
every log switch.
A: It's binary file, not text file.
B: The size of control file will be changed during time, it is not fixed.
D: It is not required to start the instance, but only mount and open database.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 319-320
Chapter 7: Managing the Physical Database Structure
Which two dynamic views can be queried when the database is started up in nomount state?
Answer: A, C
Answers A and C are correct. Before database mount and open we can only monitor information
regarding instance. So only two views can be queried at this point : V$SGA, responsible for the
SGA information, and V$INSTANCE, responsible for the instance.
View Full Document
- Fall '09