Examine the parameter values configured in your database:sga_max_size = 480Msga_target = 480Mpga_aggregate_target = 160MThe 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 several INSERT, UPDATE, and DELETE operations, significantly altering the data in 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.)
You are administering a database that supports a mixed workload. You upgrade your database from Oracle Database 11g to 12c and after the upgrade, users complain about degraded performance of some queries. The SQL plan baselines imported from the previous version are present for the queries and are loaded to the SQL Management Base as accepted plans. On further investigation, you find that better plans are generated but not used by the optimizer.Examine the parameters set for the instance:Which three tasks would you perform to improve the performance of these queries? (Choose three.)
Examine the partial PLAN_TABLE output:Which is the correct sequence of execution? (Choose the best answer.)
Which two statements are true about Active Session History (ASH)? (Choose two.)
You have been asked to use table compression for two large tables. Given are the details of the tables:The TRANS_DET table:✑ The table is used by an OLTP application.✑ High volume insert and update operations are performed on the table.✑ The table is frequently queried using index range scans.The TRANS_HISTORY table:✑ The table is used by a DSS application.✑ High volume bulk loads are performed on the table.✑ The table is used to store archival data on which large table full-table scans (FTS) are performed.Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)
Examine the partial Activity Over Time section of an Active Session History (ASH) report:Which two inferences are correct? (Choose two.)
