Actualtestscom the power of knowing 1z0 147 so if a

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: recompiles it before executing, in accordance with the automatic local dependency mechanism. Actualtests.com - The Power of Knowing 1Z0-147 So if a local procedure returns a run-time error the first time that it is invoked, indicating that the remote procedure's time stamp has changed, you should develop a strategy to re-invoke the local procedure. Incorrect Answers: A, B, C QUESTION 70: Under which two circumstances do you design database triggers? (Choose two) A. To duplicate the functionality of other triggers. B. To replicate built-in constraints in the Oracle server such as primary key and foreign key. C. To guarantee that when a specific operation is performed, related actions are performed. D. For centralized, global operations that should be fired for the triggering statement, regardless of which user or application issues the statement. Answer: C,D Explanation: C. When a specific event occurs you can specify that any related code is executed by implementing a Trigger. D. Triggers allow you have control regardless of which user or which application made the change. Incorrect Answers A. You do not want to create a Trigger when a trigger already exists for the specified event. B. You should not create a Trigger to Trigger to perform functionality that is already built into the Oracle server. QUESTION 71: Examine this procedure: CREATE OR REPLACE PROCEDURE DELETE_PLAYER (V_ID IN NUMBER) IS BEGIN DELETE FROM PLAYER WHERE ID = V_ID; EXCEPTION WHEN STATS_EXITS_EXCEPTION THEN DBMS_OUTPUT.PUT_LINE ('Cannot delete this player, child records exist in PLAYER_BAT_STAT Actualtests.com - The Power of Knowing 1Z0-147 table'); END; What prevents this procedure from being created successfully? A. A comma has been left after the STATS_EXIST_EXCEPTION exception. B. The STATS_EXIST_EXCEPTION has not been declared as a number. C. The STATS_EXIST_EXCEPTION has not been declared as an exception. D. Only predefined exceptions are allowed in the EXCEPTION section. Answer: C Explanation: You can't raise an exception that has not...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online