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-050





Question ID 1851

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE 7 sale_categoiy, sum(sale_amt) FROM sales
GROUP BY sale_categoiy;
Where would the result of this query be stored?
 

Option A

A.    PGA
 

Option B

B.    large pool

 

Option C

C.    shared pool

 

 

 

 

 

 

 

 

Option D


D.    database buffer cache

Correct Answer C
Explanation


Question ID 1852

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco1 1/password@catdb RMAN> IMPORT CATALOG rcat1 0/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)
 

Option A

A.    They deregister all databases registered in the RCAT10 catalog.
 

Option B

B.    They import metadata for all registered databases in the RCAT10 database.
 

Option C

C.    They register all the RCATIO-catalog registered databases in the RC011 catalog.

 

Option D

D.    They overwrite all stored scripts in the RC011 catalog with the same name as that in the RCAT10 catalog.

Correct Answer A,B,C
Explanation

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