This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 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
In an Oracle database, which two types of files should be multiplexed? (Choose two)
A. Data file
B. Control file
C. Password file
D. Parameter file
E. Online redo log file
Answer: B, E
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
View Full Document
- Fall '09