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:
A & C are not valid dictionary views
D: USER_SOURCE: Provides the name and the source code for all procedures created by the owner. The
source code appears in the TEXT column, and the name of the procedure appears in the NAME
column.