Diagnosing the Database and Managing Performance - OCP: Oracle Database 12c Administrator Certified Professional - page 454

18. Which of these recommendations should be followed before capturing a workload?
(Choose all that apply.)
A. Make sure your replay database has the same structure as the capture database,
except without data.
B. Make sure the replay and capture databases are similar in data content.
C. Perform a clean shutdown and restart of the capture database before beginning a
workload capture.
D. Start the capture database in unrestricted mode; then start the capture.
E. Define inclusion and exclusion filters.
19. Which is true concerning Database Replay in an Oracle Real Application
Cluster (RAC) database?
A. Workload capture is per instance.
B. You need to restart only one instance to begin workload capture.
C. Specifically in RAC, you shut down all instances, restart them individually, and
begin workload capture with the last instance started.
D. RAC does not support workload capture, but it does support workload replay.
E. None of the above.
20. Performance divergence indicated in the Workload Replay report is most likely due
to what?
A. DML and SQL statement results that do not match between the capture and
replay systems
B. When errors that occur in the capture system don't occur in the replay system
C. Top SQL statements
D. Infrastructure or system-configuration differences
E. Time-of-day differences between capture and replay systems