Unformatted text preview: A: A PL/SQL program unit is stored in the data dictionary, not in the control file.
Control file is used to mount and open database.
C: A PL/SQL program unit is not stored in the users default tablespace.
D: A PL/SQL program unit is stored in the data dictionary, not in the operating system as a file.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 317-318
Chapter 7: Managing the Physical Database Structure
Actualtests.com - The Power of Knowing 1Z0-023 QUESTION 76:
When are the base tables of the data dictionary created?
A. When the instance is created.
B. When the database is created.
C. When the catalog.sql script is executed.
D. When the catproc.sql script is executed .
Answer B is correct. The base tables of the data dictionary are created when the database is
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...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide