This preview shows page 1. Sign up to view the full content.
Unformatted text preview: own or startup & Server errors.
D. You can create an INSTEAD OF trigger on a view and use the trigger to perform DML on a
view that is inherently non-updatable.
QUESTION 30: You want to create a PL/SQL block of code that calculates discounts on customer
orders. -This code will be invoked from several places, but only within the program
What is the most appropriate location to store the code that calculates the discounts?
A. A stored procedure on the server.
B. A block of code in a PL/SQL library.
C. A standalone procedure on the client machine.
D. A block of code in the body of the program unit ORDERTOTAL.
E. A local subprogram defined within the program unit ORDERTOTAL.
QUESTION 31: Which type of argument passes a value from a procedure to the calling environment?
Parameters that are defined with an OUT mode the parameter will pass their value from the
procedure back to the calling environment.
Actualtests.com - The Power of Knowing 1Z0-147 A. This is a DataType not a parameter
B. This is a DataType not a parameter
D. When a parameter is defined with an IN mode, the parameter will only accept input from the
QUESTION 32: You create a DML trigger. For the timing information, which is valid with a DML
C. ON SHUTDOWN
E. ON STATEMENT EXECUTION
BEFORE, AFTER and INSTEAD are valid Trigger Timing Events
A, C & E are not a valid Trigger Timing event
B. INSTEAD OF, NOT INSTEAD is a valid DML Trigger Timing Event for a view
QUESTION 33: You are about to change the arguments of the CALC_TEAM_AVG function.
Which dictionary view can you query to determine the names of the procedures and
functions that invoke the CALC_TEAM_AVG function?
The data dictionary view USER_DEPENDENCIES displays information about all direct...
View Full Document
- Fall '09