This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ure, the control is transferred to
section of the calling procedure. If the exception is handled, all the
statements remain intact. If the
exception is not handled in the calling procedure's exception-handling section, all the
rolled back, and the exception propagates to the calling environment.
B. This is not true because an error is occurs on the SELECT Statement and the INSERT
Transaction is rolled back when the error is encountered.
C. The insert into the location table is also rolled back. The insert_locaton calls the
insert_dept Stored Procedure, this procedure fails and control is passed back to the
calling procedure which does not have an exception section , therefore both the insert
into the locations table and the insert into the departments table are rolled back.
D. Due to the lack of exception handling the inserts into the locations & departments are
QUESTION 56: The creation of which database objects will cause a DDL trigger to fire? (Choose all that
G. Database links
Answer: A,B, C,D,E
DDL triggers fire for clusters, functions, indexes, packages, procedures, roles, sequences,
synonyms, tables, tablespaces, triggers, types, views, or users.
QUESTION 57: Which two program declarations are correct for a stored program unit? (Choose two)
A. CREATE OR REPLACE FUNCTION tax_amt
B. CREATE OR REPLACE PROCEDURE tax_amt
Actualtests.com - The Power of Knowing 1Z0-147
C. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER)
D. CREATE OR REPLACE FUNCTION tax_amt
E. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER(10, 2))
A. This is the correct syntax for creating a Function.
The syntax for creating a function is similar to that of creating a procedure with the
addition of a RETURN
statement. The following is the syntax for CREATE FUNCTION...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09