D the specification and body of the package are

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: 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. Answer: C,E Explanation: 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 database. Incorrect Answers: 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 Answer: C Explanation: Correct Answer C: The SQL *Plus command SHOW ERRORS or SHOW ERR Command extracts the error information from the USER_ERRORS view Incorrect Errors 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. Answer: A,B,C,D Explanation: Correct Answers 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.

Ask a homework question - tutors are online