AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-146





Question ID 2819

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 2820

You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed the following command to check the status for the result cache:,
SQL> select dbms_result_cache.status() from dual;
You receive the following output:
DBMS_RESULT_CACHE.STATUS()
DISABLED
Identify the reason for the output.
 

Option A

A.    The RESULT_CACHE_MODE parameter is set to FORCE.
 

Option B

B.    The RESULT_CACHE_MODE parameter is set to MANUAL.
 

Option C

C.    The database instance is not able to allocate memory for the result cache.
 

Option D

D.    The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0.
 

Correct Answer D
Explanation

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