Pass4sure 1Z0-050 Question Answer

Question NO: 1

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

A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots

Answer: A, C

Question NO:2

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

A. The clients must be created manually on the test machines to perform more realistic testing.
B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

Answer: C, D