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 2733

Which two types of metadata can be retrieved by using the various procedures in the DBMS_METADATA PL/SQL package? (Choose two.)
 

Option A

A.    report of invalidated objects in a schema

 

Option B

B.    report of statistics of an object in the database
 

Option C

C.    DDL for all object grants on a table in the database
 

Option D

D.    data definition language (DDL) for all objects in a schema

Correct Answer C,D
Explanation


Question ID 2734

The database instance was recently started up. Examine the following parameter settings for the database instance:
NAME TYPE VALUE
result_cache_max_result integer 5 result_cache_max_size big integer 0 result_cache_mode string MANUAL result_cache_remote_expiration integer 0
 
You reset the value for the result cache
_

 
max_size parameter by issuing the following command:
 
SQL> ALTER SYSTEM SET result_cache_max_size = 1056k SCOPE = BOTH; System altered.
Which statement is true in this scenario?
 

Option A

A.    1056 KB is allocated for the result cache and the result cache is enabled.
 

Option B

B.    1056 KB is allocated for the result cache, but the result cache is disabled.
 

Option C

C.    The results for only the queries that have the RESULT_CACHE hint are cached.

 

Option D

D.    The results for all the queries except those having the NO_RESULT_CACHE hint are cached.

Correct Answer B
Explanation

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