Free 1Z0-148 Web TestEngine Demo

Q32 Single choice

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.

1Z0-148 Web TestEngine demo