This preview shows page 1. Sign up to view the full content.
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
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
Answer A and B are correct. Database even trigger fires when commands DROP USER or
ALTER view issued.
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.
- Fall '09