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
D) is incorrect
The utldtree.sql SQL script creates the view DEPTREE, which contains information on the object dependency tree, and the view IDEPTREE, a presorted, pretty-print version of DEPTREE.
http://web.cerritos.edu/hohly/SitePages/Oracle/PL_SQL/PLSQL_course_materials%206_07/PLSQL_s12_l01.pdf
Displaying Direct and Indirect Dependencies
Run the script utldtree.sql that creates the objects that enable you to display the direct and indirect dependencies.
This script creates four objects:
• A temp table deptree_temptab to hold dependency data
• A procedure deptree_fill to populate the table
• Two views deptree and ideptree(indented pretty dependency tree) to select and format dependency data from the populated table.
Like below, you want to get the dependency on scott.employee table
1. @@utldtree.sql
2. execute deptree_fill
execute deptree_fill(‘TABLE’,’SCOTT’,’EMPLOYEES’)
3. query deptree or ideptree
SELECT nested_level, type, name
FROM deptree
ORDER BY seq#;
result:
nested_level type name
0 table employees
1 view v_employees
2 procedure p_process_employees