Incorrect answers a a plsql program unit is stored in

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

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online