Oracle 1z1-064 Value Pack (Frequently Bought Together)

You upgrade your database from Oracle Database 11g to 12c. You capture execution plans for a resource-intensive SQL workload before the upgrade. After the upgrade, you load the plans into the SQL Management Base.
Examine the parameters set for the instance:

Which two statements are true?

• A. New execution plans generated will always be added to the SQL plan baselines as accepted plans.
• B. A better execution plan may be found for the SQL statements and can be evolved manually.
• C. New execution plans cannot be evolved until execution plans from the previous version are dropped.
• D. New execution plans generated will always be added to the SQL plan baselines as fixed plans.
• E. New SQL plan baselines might be generated automatically for the repeatable SQL statements.

Which two statements are true about Compare Period ADDM? (Choose two.)

• A. It is automatically invoked whenever ADDM is run by default.
• B. It can be used to create a comparison report between the Database Replay workload capture report and the replay report.
• C. It is automatically invoked whenever the AWR Compare Period report is invoked.
• D. It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.

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.)

• A. limiting the amount of time that a session is idle and blocking other sessions of the ERP application
• B. limiting the amount of undo generated by operations performed by sessions created by the ERP application
• C. allocating a lower percentage of CPU to sessions used by the REPORTING apnplication than to those used by the ERP application
• D. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload
• E. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

Examine the parameters set for your database instance:

You are administrating a database that supports a DSS workload. You make some changes to the sizes of memory components. Consequently, you receive this error:

Which three actions might resolve the issue?

• A. enabling Automatic Shared Memory Management for the database instance
• B. pinning the cursors in the shared pool
• C. setting the value of MEMORY_MAX_TARGET to the value of the SGA_MAX_SIZE parameter
• D. enabling Automatic Memory Management for the database instance
• E. increasing the size of the shared pool
• F. setting the PGA_AGGREGATE_TARGET parameter to 0 and the MEMORY_TARGET parameter to the value of the PGA_AGGREGATE_TARGET parameter

Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)

• A. queries repeatedly fetching blocks that are not in the database buffer cache
• B. queries not using indexes and performing full table scans
• C. the shared pool is inadequately sized
• D. cursors are closed explicitly after each execution
• E. repeated simultaneous access to a block or small number of blocks
• F. too many sort operations being performed