ExamDumpster

Free 1z0-064 sample questions

Each free 1z0-064 sample question below shows the correct answer and explains it. They cover AWR reports, SQL tuning and memory settings. The exam is retired, so use them for 12c review; 1Z0-084 is the current exam.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 6 of 12 free sample questions.

Question 1Choose 2

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

Question 2Choose 2

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

Question 3Choose 2

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

Question 4Choose 2

You plan to upgrade your production database from Oracle Database 11 g to 12c and also to introduce new objects to the database. You also want to upgrade the hardware. You have already created a test system with the upgrades to be made to the production database. As part of the testing, you want to: • analyze and compare the overall database workload with concurrency and transaction characteristics • find SQL statements that might get regressed because of the upgrade • analyze execution plans for SQL statements for which performance might get regressed • analyze the impact of new schema objects on database performance Which two tools would you recommend to achieve the objective? (Choose two.)

Question 5Choose 2

For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)

Question 6Choose 2

Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes queries containing a mix of literals and bind variables? (Choose two.)

6 more free samples are waiting

Create a free account to unlock the whole 1z0-064 sample bank, or get full access to all 307 practice questions in the simulator.

Create account