Oracle Database 12c: Performance Management and Tuning - 1z1-064 Exam Practice Test
Examine the parameters:
Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and a high number of direct path write wait events.
Which two actions could improve the performance? (Choose two.)
Your database supports a mixed workload and users have dedicated server connections. Users complain about the increased response time of a few queries that are performing large sort operations. On investigation, you notice an increase in the number of multipass work area executions and a high number of direct path write wait events.
Which two actions could improve the performance? (Choose two.)
Correct Answer: B,C
Vote an answer
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.)
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.)
Correct Answer: A,D,F
Vote an answer
You are administrating a database that supports a DSS workload. Syntactically similar queries using joins and aggregate functions are frequently executed by users to fetch data from remote databases by using database links.
Which three tasks should you perform to improve the performance of these queries?
Which three tasks should you perform to improve the performance of these queries?
Correct Answer: A,C,G
Vote an answer
You want to capture AWR data to monitor performance variation every Monday between 9:00 AM and 12:00 PM for three months and automatically remove the older AWR data every fortnight.
How would you achieve this? (Choose the best answer.)
How would you achieve this? (Choose the best answer.)
Correct Answer: D
Vote an answer
Examine the partial PLAN_TABLE output:
Which is the correct sequence of execution? (Choose the best answer.)
Which is the correct sequence of execution? (Choose the best answer.)
Correct Answer: A
Vote an answer
You execute this query twice in a session:
Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.
Which two statements are true? (Choose two.)
Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.
Which two statements are true? (Choose two.)
Correct Answer: A,E
Vote an answer
You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)
Correct Answer: B,E
Vote an answer