Which statement is true about the output of the query?

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?

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?

A.
It displays all PL/SQL code objects created by user OE that reference any table or view owned
by other users except SYS and SYSTEM..

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

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

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



Leave a Reply 3

Your email address will not be published. Required fields are marked *


PIERO

PIERO

OPS….. not created by user sys obviously…

A