READ Free Dumps For Oracle- 1z0-146

Question ID 2769	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?
Option A	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..
Option B	B.    It displays no rows because this query needs to be executed as the user SYS for required results.
Option C	C.    It displays all PL/SQL code objects that reference a table or view directly for all the users in the database.
Option D	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.
Correct Answer	A

Explanation

Question ID 2770	Match the following external C procedure components with their descriptions: 1.    External procedure a. a process that starts the extproc process 2.    Shared library b. a session-specific process that executes the external procedure 3.    Alias library c. schema object that represents the operating system (OS) shared library    4.    The extproc process d. operating system file that stores the external procedure 5.    Listener process e. a unit of code written in C
Option A	A. 1-e;    2-d;    3-c;    4-b; 5-a
Option B	B. 1-c;    2-d;    3-e;    4-b; 5-a
Option C	C. 1-e;    2-c;    3-d;    4-b; 5-a
Option D	D. 1-a;    2-d;    3-e;    4-c; 5-b
Correct Answer	A

Explanation

Previous-Page 1 2. . . 16 17 18 19 20 21 22. . . 93 94 Next-Page

Send email to admin@getfreedumps for new dumps request!!!