Oracle
1Z0-146 · Question #39
1Z0-146 Question #39: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #39. The question stem and answer options stay visible for context.
Question
To examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE: SQL> SELECT owner || '.' || NAME refs_table , referenced_owner || '.' || referenced_name AS table_referenced FROM all_dependencies WHERE owner = USER AND TYPE IN ('PACKAGE', 'PACKAGE BODY','PROCEDURE', 'FUNCTION') AND referenced_type IN ('TABLE', 'VIEW') AND referenced_owner NOT IN ('SYS', 'SYSTEM') ORDER BY owner, NAME, referenced_owner, referenced_name; Which statement is true about the output of the query?
Options
- AIt displays all PL/SQL code objects created by user OE that reference any table or view owned by
- BIt displays no rows because this query needs to be executed as the user SYS for required results.
- CIt displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
- DIt displays only those PL/SQL code objects created by the user OE that reference a table or view
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.