Sql script generates public synonyms for the data

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: 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 77: 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 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...
View Full Document

Ask a homework question - tutors are online