1z0-064 Sample Questions & Answers

Examine the parameters set for your database instance:

To investigate the slow response time of queries on the TRANS table, you gather table and execute the query:

The table is stored in a tablespace with Automatic Segment Space Management (ASSM), and some rows of the TRANS table are migrated and chained.

Which two actions would you recommend to improve query response time?

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.

Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

Which three actions should you perform to reduce shared pool fragmentation and avoid the “ORA-04031: unable to allocate .... bytes of shared memory” error for the shared pool? (Choose three.)

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

You are administering a database that supports an OLTP workload. Users complain about the degraded response time of a query. You want to gather new statistics for objects accessed by the query and test query performance with the new statistics without affecting other sessions connected to the instance.

The STALE_PERCENT statistic preference is set to a default value and the STATISTICS_LEVEL parameter is set to TYPICAL.

Which two actions would you take to accomplish the task? (Choose two.)

Examine the parameters set for a database instance:

An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again.

Which two would you recommend as long-term solutions for this issue? (Choose two.)