This preview shows page 1. Sign up to view the full content.
Unformatted text preview: body is optional.
D. The specification and body of the package are stored together in the database.
E. The specification and body of the package are stored separately in the database.
Correct Answer C: A Package must have a specification. A Package may also have a
body but it is not necessary. A Package without a package body are referred to as a
bodiless package. If a package specification contains only variables, constants, types,
exceptions, and a call specification, the package body is not required.
Correct Answer E: The package specification and body are stored separately in the
A. A package body is optional
B. The package specification is required and the package body is optional
D. The package specification and the body are stored in the database as separate objects.
QUESTION 26: Actualtests.com - The Power of Knowing 1Z0-147 When creating a function in SQL *Plus, you receive this message:
"Warning: Function created with compilation errors."
Which command can you issue to see the actual error message?
A. SHOW FUNCTION_ERROR
B. SHOW USER_ERRORS
C. SHOW ERRORS
D. SHOW ALL_ERRORS
Correct Answer C: The SQL *Plus command SHOW ERRORS or SHOW ERR
Command extracts the error information from the USER_ERRORS view
A. this is an invalid object
B & C are Invalid Commands
QUESTION 27: Which four triggering events can cause a trigger to fire? (Choose four)
A. A specific error or any errors occurs.
B. A database is shut down or started up.
C. A specific user or any user logs on or off.
D. A user executes a CREATE or an ALTER table statement.
E. A user executes a SELECT statement with an ORDER BY clause.
F. A user executes a JOIN statement that uses four or more tables.
A, B & C: These are system events. Triggering events that cause system triggers to fire
are Server Errors, Users Logging on or off the database, Database startup or shutdown,
D: Database Triggers fire on DDL Statements including a CREATE, ALTER or
DROP of a Table
QUESTION 28: Examine this procedure:
CREATE OR REPLACE PRO...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09