D you can create an instead of trigger on a view and

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: 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 unit ORDERTOTAL. 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. Answer: E QUESTION 31: Which type of argument passes a value from a procedure to the calling environment? A. VARCHAR2 B. BOOLEAN C. OUT D. IN Answer: C Explanation: Parameters that are defined with an OUT mode the parameter will pass their value from the procedure back to the calling environment. Incorrect Answers: 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 calling environment. QUESTION 32: You create a DML trigger. For the timing information, which is valid with a DML trigger? A. DURING B. INSTEAD C. ON SHUTDOWN D. BEFORE E. ON STATEMENT EXECUTION Answer: D Explanation: BEFORE, AFTER and INSTEAD are valid Trigger Timing Events Incorrect Answers: 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? A. USER_PROC_DEPENDS B. USER_DEPENDENCIES C. USER_REFERENCES D. USER_SOURCE Answer: B Explanation: The data dictionary view USER_DEPENDENCIES displays information about all direct...
View Full Document

Ask a homework question - tutors are online