ExamQuestions.com

Register
Login
Oracle Database 11g Advanced PLSQL Exam Questions

Oracle

Oracle Database 11g Advanced PLSQL

63 / 68

Question 63:

Examine the dependencies between all PL/SQL objects and the tables and views they reference, you executed the following query as the user OE: 
image
Which statements is true abou the output of the query? 

Answer options:

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 diplays no rows because this query needs to be executed as a 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