You are about to change the arguments of the CALC_TEAM_AVG function.
Which dictionary view can you query to determine the names of the procedures and functions that
invoke the CALC_TEAM_AVG function?
A.
USER_PROC_DEPENDS
B.
USER_DEPENDENCIES
C.
USER_REFERENCES
D.
USER_SOURCE
Explanation:
The data dictionary view USER_DEPENDENCIES displays information about all direct
dependencies within your schema.
Incorrect Answers:
D: USER_SOURCE: Provides the name and the source code for all procedures created by the
owner. Thesource code appears in the TEXT column, and the name of the procedure appears in
the NAMEcolumn.