You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight. How would you achieve this? (Choose the best answer.) A.…

Your database supports a mixed workload. The ERP application creates short sessions and performs small, random I/Os; the REPORTING application executes long-running DSS queries. You want to set a priority for the workload generated by the ERP application and optimize…

In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of maximum trigger as an alert. What is the outcome? (Choose the best answer.) A. It generates an…

Examine the partial TKPROF output for an SQL statement: Which two inferences can definitely be made from this output? (Choose two.) A. Array fetch operations were not performed for this query. B. No hard parse was performed for this query.…