READ Free Dumps For Oracle- 1z0-023
Question ID 8789 | What is the purpose of Oracle Wrapper utility, also known as the Wrap Utility or PL/SQL wrapper?
|
Option A | To export a users schema.
|
Option B | To group related PL/SQL packages, functions, and procedures.
|
Option C | To hide application code by encrypting PL/SQL package bodies.
|
Option D | To hide application code by encrypting PL/SQL package applications.
|
Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct. Oracle Wrapper utility is used to hide application code by encrypting PL/SQL package bodies. Incorrect Answers: A: This utility does not export a user schema, Oracle Export utility does. B: It does not group related PL/SQL packages, functions, and procedures. D: Oracle Wrapper utility is used to hide application code by encrypting PL/SQL package bodies, not package applications. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 315-318 Chapter 7: Managing the Physical Database Structure
Question ID 8790 | Which two commands can cause a database event trigger to fire? (Choose two)
|
Option A | DROP USER
|
Option B | ALTER VIEW
|
Option C | CALL PROCEDURES
|
Option D | CREATE DATABASE
|
Correct Answer | AB |
Explanation Explanation/Reference: 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 Certification Exam Guide, Jason S. Couchman, p. 431-433 Chapter 9: Managing Database Objects II