Download Oracle.1z0-064.NewDumps.2018-05-06.56q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-064 |
| Exam Name: | Oracle Database 12c: Performance Management and Tuning |
| Date: | May 06, 2018 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)
- Use the Resource Manager.
- Enable SQL Trace at the session level.
- Create a service.
- Use a dedicated server configuration.
- Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.
Correct answer: AB
Question 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.)
- Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
- Set the STATISTICS_LEVEL parameter to ALL for the instance.
- Set the INCREMENTAL preference to TRUE, and then gather statistics.
- Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
- Set the PUBLISH statistic preference to FALSE, and then gather statistics.
- Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
Correct answer: BE
Question 3
Examine the structure of the EMPLOYEES table.
EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.
Which two actions should you perform to make the cursor bind aware? (Choose two.)
- Create a histogram on the DEPARTMENT_ID column.
- Change the default CURSOR_SHARING value to FORCE.
- Execute the query with the same DEPARTMENT_ID value multiple times.
- Create an index on the DEPARTMENT_ID column.
- Gather statistics for the index.
- Regather statistics on the table.
Correct answer: CD
