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. creating two resource plans with resource limits defined for the workload generated by the applications and automatically changing resource plans based on the workload

D. allocating a lower percentage of CPU to sessions used by the REPORTING application than to those used by the ERP application

E. limiting the physical I/O performed by the sessions or users of the ERP application that are connected to the database

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.

C. The number of logical I/Os is almost equal to the number of physical I/Os.

D. Another transaction held a shared lock on the table, thereby causing a significant delay.

E. An uncommitted transaction made a series of updates to the NAME_ID column just before the execution of this query.

Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:

What should you examine to diagnose the cause of the top three wait events? (Choose the best answer.)

A. the V$ACTIVE_SESSION_HISTORY view

B. the Time Model Statistics section of the AWR report

C. the SQL statements based on elapsed time from the AWR report

D. the Latch Activity section

E. the Segment Statistics section of the AWR report

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

A. Use the Resource Manager.

B. Enable SQL Trace at the session level.

C. Create a service.

D. Use a dedicated server configuration.

E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

Your database supports an OLTP system.

Examine the parameter values configured in your database:

The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.

You execute the commands:

SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS(`SH',`CUSTOMERS');

PL/SQL procedure successfully completed.

SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);

Index created.

You then perform a series of INSERT, UPDATE, and DELETE operations on the table.

View the Exhibit to examine the query and its execution plan.

Which three options would improve the performance of the query? (Choose three.)

A. creating a bitmap index on the COUNTRY_ID column

B. regathering statistics on the CUSTOMERS table

C. creating a histogram on the COUNTRY_ID column

D. increasing the size of the PGA

E. creating a SQL profile

F. creating a KEEP cache