Answer explanation catsql catalog and dictionary

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: Cat*.sql = Catalog and dictionary information Dbms*.sql = Database package specifications. Prvt*.plb = Wrapped database package code Utl*.sql = Views and table for database utilities. Cat*.sql administrative scripts are used to store catalog and dictionary information. Dbms*.sql scripts define database package specifications. Prvt*.plb scripts are used for wrapped database package code. Utl*.sql scripts defines views and tables for database utilities. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 312-318 Chapter 7: Managing the Physical Database Structure QUESTION 44: Which two commands can cause a database event trigger to fire? (Choose two) A. DROP USER B. ALTER VIEW C. CALL PROCEDURES D. CREATE DATABASE Answer: A, B Explanation: Answer A and B are correct. Database even trigger fires when commands DROP USER or ALTER view issued. Incorrect Answers: C: This trigger will not fire after procedure calling. D: This trigger will not fire with CREATE DATABASE command. Oracle 8, DBA Certifi...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online