Read online free dumps for Oracle- 1z0-146

Here you can read online questions and answers for Oracle Exam 1z0-146 (Oracle Database 11g Advanced PL/SQL ) 100% free...

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
Description
Update Date and Time 2016-01-14 08:10:07

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
Description
Update Date and Time 2016-01-14 08:10:51