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 1901

The following databases are registered in the base recovery catalog: PROD1 „ PROD2, and PROD3. The database user CAT OWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1 .SQL> GRANT recovery_catalog_owner TO vpc1;
2.    RMAN> CONNECT CATALOG vpc1/password@catdb;
3.    RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.    RMAN> CONNECT CATALOG catowner/password@catdb;
5.    RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?
 

Option A

A.    1,4,5,2,3
 

Option B

B.    1,4,3,2,5
 

Option C

C.    4,5,2,3, 1

 

Option D

D.    2,3,4,5, 1

Correct Answer B
Explanation


Question ID 1902

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

Option A

A.    The plan baselines can be evolved over time to produce better performance
 

Option B

B.    The newly generated plans are directly placed into the SQL plan baseline without being verified.
 

Option C

C.    The new SQL statements initially run with the plans that are known to produce good performance under standard
test configuration.
 

Option D

D.    The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
 

Correct Answer A,C
Explanation

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