This preview shows page 1. Sign up to view the full content.
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 ' ;
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.
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
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
A. The function must not end th...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09