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?

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?

Accepted Answer

A. It displays all PL/SQL code objects created by user OE that reference any table or view owned by

Answer

B. It displays no rows because this query needs to be executed as the user SYS for required results.

Answer

C. It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.

Answer

D. It displays only those PL/SQL code objects created by the user OE that reference a table or view

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…

Question

Options

How the community answered

Community Discussion