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 ‘ ;
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
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.