In which three situations does DB time always increase? (Choose three.)
Which two situations can lead to sparsely populated index blocks? (Choose two.)
For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)
Which two statements are true about Compare Period ADDM? (Choose two.)
You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latestAWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time.Which two can be reasons for this? (Choose two.)
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 resource usage for them.Which three objectives can be achieved by the Resource Manager? (Choose three.)
