READ Free Dumps For Oracle- 1z0-023
| Question ID 8769 | Which dynamic view should a DBA query to obtain information about the different sections of the control file?
|
| Option A | V$CONTROLFILE
|
| Option B | DBA_CONTROLFILE
|
| Option C | V$CONTROLFILE_RECORD_SECTION
|
| Option D | DBA_CONRTOLFILE_RECORD_SECTION
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. The V$CONTROLFILE_RECORD_SECTION view is used to show information about different sections in the control file. For example, there is a section in the control file that keeps track of the sequence number of the current online redo log, a section that contains information about the physical disk file layout of the Oracle database, and so on. Incorrect Answers: A: The V$CONTROLFILE view corresponds to the values set for the initialization parameter CONTROL_FILES. The view has only two columns, NAME and STATUS. B: There is no DBA_CONTROLFILE view in Oracle. D: There is no DBA_CONTROLFILE_RECORD_SECTION view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 321 Chapter 7: Managing the Physical Database Structure
| Question ID 8770 | What are two characteristics of the control file? (Choose two)
|
| Option A | It is a text file.
|
| Option B | It is a fixed size.
|
| Option C | It should be multiplexed.
|
| Option D | It is required to start the instance.
|
| Option E | It must be updated at every log switch.
|
| Correct Answer | CE |
Explanation Explanation/Reference: 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