摘要:
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to anonzero value, you will enable which of the following memory-man 阅读全文
摘要:
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?A. Automatic PGA Memory Ma 阅读全文
摘要:
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 t 阅读全文
摘要:
Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to 阅读全文
摘要:
Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)A. Make sure your replay database has the same 阅读全文
摘要:
Which of the following represents the correct sequence of events for Database Replay?A. Capture, analyze, preprocess, replayB. Capture, preprocess, an 阅读全文
摘要:
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automati 阅读全文
摘要:
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?A. Create new indexes.B. Modify existing indexes.C 阅读全文
摘要:
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A 阅读全文
摘要:
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task 阅读全文