Read online free dumps for Oracle- 1z0-050

Here you can read online questions and answers for Oracle Exam 1z0-050 (Oracle Database 11g New Features for Administrators ) 100% free...

Question ID 1767

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

Option A

A.    Cursor cache
 

Option B

B.    Stored outline
 

Option C

C.    SQL Tuning Set

 

Option D

D.    Automatic Workload Repository (AWR) snapshots

Correct Answer A,C
Description
Update Date and Time 2015-12-05 14:13:24

Question ID 1771

Which two statements about workload capture and replay operations are true? (Choose two.)

Option A

A.    The clients must be created manually on the test machines to perform more realistic testing.
 

Option B

B.    Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

 

Option C

C.    Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
 

Option D

D.    The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

Correct Answer C,D
Description
Update Date and Time 2015-12-05 14:19:14