You observed in your database that the queries formerly executed in 5 seconds now take longer
time.View the Exhibit and analyze the output of the query that you executed to find the problem.Which is the primary concern?

• A. the number of chained and migrated rows
• B. the number of disk sorts
• C. the number of full table scans
• D. the number of rows fetched based on rowid

Examine the initialization parameter values for the instance given below: NAME TYPE VALUE
optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2 optimizer_features_enable string 11.1.0.6 optimizer_index_caching integer 0 optimizer_index_cost_adj integer 100 optimizer_mode string ALL_ROWS db_file_multiblock_read_count integer 64 The index created on the column used in the WHERE clause of the query. You notice that the query is not using the index. Instead of an index scan, a full table scan is used. View the Exhibit and examine the autotrace output for a query.

What could be the reason for it? (Choose all that apply.)

• A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.
• B. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.
• C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.
• D. The statistics for the table and all the indexes associated with the table are not current.

You created two services HR and FINANCE on a single instance database. These services are used by the middle-tier applications to connect to the database by using connection pools. The applications have various modules and you asked the developers to invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure to set the module name and action in the code for the application. As part of performance management, you want to gather statistics for these modules and see the amount of workload created by these modules. What would you recommend to accomplish the task?

• A. Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics for a module and querying the V$SERV_MOD_ACT_STATS view
• B. Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics for a module and querying the V$SERVICE_STATS view
• C. Using the DBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE procedure to collect statistics for a module and querying the V$SERVICE_EVENT view
• D. Querying the V$SERVICE_STATS view because the statistics for the modules are collected automatically when you invoke the DBMS_APPLICATION_INFO.SET_MODULE procedure

Examine the SQL statement given below: SQL> EXPLAIN PLAN for SELECT department_name,count(*) FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id GROUP BY d.department_name; To view the execution plan for the statement, you queried plan_table. View the Exhibit and examine the execution plan.Which two statements are true about the execution plan? (Choose two.)

• A. The execution plan is displayed for the executed SQL statement.
• B. The EXPLAIN PLAN command does not actually execute the statement.
• C. The row with the id column having a value of 0 is the first step executed in the execution plan.
• D. The row with the id column having a value of 4 is the first step executed in the execution plan.

There are 500 users of an online transaction processing (OLTP) application that resides in your database. The system had been maintaining an average response rate of 10 seconds as specified by the Service-Level Agreement (SLA).This morning you were informed that for the past four days
the average response time has gone up to 15-20 seconds. No changes have been made to the hardware or networking setup.What is the first thing that you should do to diagnose the cause of the slow response time?

• A. Determine whether the application is performing excessive I/O due to poor access path choice.
• B. Determine whether the slow response is wait bound or CPU bound.
• C. Determine whether it is a memory configuration issue.
• D. Determine whether new tablespaces have been created on the disks that are being used by the existing tablespaces.