Which two dictionary views track dependencies? (Choose two)
A.
USER_SOURCE
B.
UTL_DEPTREE
C.
USER_OBJECTS
D.
DEPTREE_TEMPTAB
E.
USER_DEPENDENCIES
F.
DBA_DEPENDENT_OBJECTS
Explanation:
D: DEPTREE_TEMPTAB is a temporary table used to store dependency information returned by
the DEPTREE_FILL procedure.
E: USER_DEPENDECIES is used to display direct dependencies. ALL _DEPENDENCIES and
DBA_DEPENDENCIES also store dependency information.
Incorrect answers
A: USER_SOURCE describes the text source of the stored objects owned by the current user
B: UTL_DEPTREE is not a valid data dictionary view.
C: USER_OBJECTS contains basic information about all objects owned by the current user, but
does not contain dependency information
F: DBA_DEPENDENT_OBJECTS this is not a valid data dictionary view however there is a
DBA_DEPENDENCIES view