Question 96 the addplayer procedure inserts rows into

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: etched from the cursor. D. This would be the output if you executed the proc1 cursor fro the second time. QUESTION 96: The add_player procedure inserts rows into the PLAYER table. Which command will show this directory dependency? A. SELECT * FROM USER_DEPENDENCIES WHERE REFERENCD NAME = ' PLAYER ' ; B. SELECT * FROM USER DEPENDENCIES WHERE REFERENCD NAME = ' ADD PLAYER ' ; C. SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR' ; D. SELECT * FROM USER DEPENDENCIES WHERE REFERENCD NAME = ' TABLE ' ; Answer: A Explanation: The REFERENCED_NAME Column displays the name of the referenced object. If you specify Player in the Referenced name column all objects that reference the PLAYER Table(Direct Dependecies) will be displayed. Incorrect Answers Actualtests.com - The Power of Knowing 1Z0-147 B. This would show all dependencies on the add_player, not the PLAYER Table. C. This would not display anything. The TYPE Column list the dependent object's type (procedure, function, package, package body,trigger, or view. D. This would not display anything. If you wanted all dependencies for OBJECTS of TYPE TABLE you would filter on the TYPE Column. QUESTION 97: When using a packaged function in a query, what is true? A. The COMMIT and ROLLBACK commands are allowed in the packaged function. B. You can not use packaged functions in a query statement. C. The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried. D. The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery. E. The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used. Answer: C Explanation: A function, stand-alone or package can't execute DML (INSERT, UPDATE & DELETE) against the table that is being queried. This will result in a mutating table and generate a runtime error. Incorrect Answers A. The function must not end th...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online