Which five pieces need to be identified choose five 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: s C and D are incorrect syntax and will result in an error QUESTION 93: You need to create a DML trigger. Which five pieces need to be identified? (Choose five) A. Table B. DML event C. Trigger body D. Package body E. Package name F. Trigger name G. System event H. Trigger timing Answer: A, B, C, F, H Explanation: Incorrect answers: Actualtests.com - The Power of Knowing 1Z0-147 D. A Package body is not part of a trigger. You may call procedure which can be written in PL/SQL, JAVA or C that is part of a package but this is not required. E. Package Name. A package is not part of the trigger definition G. System Event is not associated with a DML Trigger QUESTION 94: Procedure PROCESS_EMP references the table EMP. Procedure UPDATE_EMP updates rows if table EMP through procedure PROCESS_EMP. There is a remote procedure QUERY_EMP that queries the EMP table through the local procedure PROCESS_EMP. The dependency mode is set to TIMESTAMP in this session. Which two statements are true? (Choose two) A. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated. B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time. C. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time. D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time. E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time. Answer: B, E Explanation: B. The UPDATE_EMP references the local Procedure PROCESS_EMP. Local Dependent objects are immediately set to invalid whenever the referenced object is changed. The Oracle server will recompile the dependent object upon execution. E. Since QUERY_EMP is a remote procedure, this procedure will be set to invalid the fi...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online