READ Free Dumps For Oracle- 1z0-023
| Question ID 8821 | When are the base tables of the data dictionary created?
|
| Option A | When the instance is created.
|
| Option B | When the database is created.
|
| Option C | When the catalog.sql script is executed.
|
| Option D | When the catproc.sql script is executed .
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. The base tables of the data dictionary are created when the database is created. Incorrect Answers: A: There are no base tables in the data dictionary when the instance is started first time without CREATE DATABASE statement. C: catalog.sql script generates public synonyms for the data dictionary views. It runs after base tables were created in the data dictionary. D: This script creates several different data dictionary components used in everything related to PL/SQL in the Oracle database, this script runs after catalog.sql script. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 314-316 Chapter 7: Managing the Physical Database Structure
| Question ID 8822 | In an Oracle database, which two types of files should be multiplexed? (Choose two)
|
| Option A | Data file
|
| Option B | Control file
|
| Option C | Password file
|
| Option D | Parameter file
|
| Option E | Online redo log file
|
| Correct Answer | BE |
Explanation Explanation/Reference: Explanation: Answers B and E are correct. Control files and online redo logs files should be multiplexed for more reliability. Depending on the availability of multiple disk drives, the DBA should store multiple copies of the control files to minimize the risk of losing these important physical disk resources. In order to improve recoverability in the event of disk failure, the DBA should configure Oracle to multiplex, or store each redo log member in a group on different disk resources. Incorrect Answers: A: Data files do not need to be multiplexed. C: Password file does not need to be multiplexed. D: Parameter file do not need to be multiplexed. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 323-332 Chapter 7: Managing the Physical Database Structure