It is a text file b it is a fixed size c it should be

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: Answers C and E are correct. The control file should be multiplexed and it must be updated at every log switch. Incorrect Answers: 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 QUESTION 23: Which two dynamic views can be queried when the database is started up in nomount state? (Choose two) A. V$SGA B. V$LOGFILE C. V$INSTANCE D. V$CONTROLFILE E. V$DATAFILE_HEADER Answer: A, C Explanation: 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. Incorr...
View Full Document

Ask a homework question - tutors are online