The add_player procedure inserts rows into the PLAYER table. Which command will show this
directory dependency?
A.
SELECT * FROM USER_DEPENDENCIES
WHERE REFERENCED_NAME = ‘PLAYER’;
B.
SELECT * FROM USER DEPENDENCIES
WHERE REFERENCED_NAME = ‘ADD_PLAYER’;
C.
SELECT * FROM USER_DEPENDENCIES
WHERE TYPE = ‘DIR’;
D.
SELECT * FROM USER DEPENDENCIES
WHERE REFERENCED_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.