PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2
QUESTION 1
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.)
A. Set the STALE_PERCENT statistic preference to a higher value than the default, and then gather statistics.
B. Set the STATISTICS_LEVEL parameter to ALL for the instance.
C. Set the INCREMENTAL preference to TRUE, and then gather statistics.
D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE for the session in which you want to test the query.
E. Set the PUBLISH statistic preference to FALSE, and then gather statistics.
F. Set the NO_INVALIDATE statistic preference to TRUE, and then gather statistics.
Answer: DE
QUESTION 2
You plan to upgrade your production database from Oracle Database 11g 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.)
A. Database Replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. Automatic Database Diagnostic Monitor (ADDM) compare periods report
E. SQL Performance Analyzer
F. Automatic Workload Repository (AWR) compare periods report
Answer: BE
QUESTION 3
In which three situations can dynamic statistics be used? (Choose three.)
A. when the sampling time is a small fraction of the total time for a query
B. when an execution plan is suboptimal because of complex predicates
C. when extended statistics are not available for SQL statements that use complex predicates
D. when a query is on a partitioned table with a global index
E. when index statistics are missing on a column that is used in SQL statements with highly selective filters
Answer: ABC
Explanation:
https://docs.oracle.com/database/121/TGSQL/tgsql_statscon.htm#TGSQL341
QUESTION 4
You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables. Which three aspects should you consider before you choose this compression method? (Choose three.)
A. Check whether direct path load operations are used to insert rows in the table.
B. Check whether the table is frequently queried using full table scans as column store compression only minimizes I/O during full table scans.
C. Check whether the table is frequently updated because it will have overhead for insert and update operations.
D. Check whether the table has LOB columns as it will minimize I/O for the queries.
E. Check whether the table blocks are sparsely populated as this will defragment the blocks.
Answer: ABD
QUESTION 5
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 high number of direct path write wait events. Which two actions could improve the performance? (Choose two.)
A. increasing the value of the SORT_AREA_SIZE parameter
B. increasing the value of the PGA_AGGREGATE_TARGET parameter
C. enabling Automatic Memory Management for the instance
D. increasing the size of the default temporary tablespace
E. using parallel hint in queries performing large sort operations
F. enabling Automatic Shared Memory Management for the instance
Answer: AF
QUESTION 6
Examine the parameters set for a database instance supporting a mixed workload:
The database instance supports shared server and dedicated server connections simultaneously. Users complain about increased response times of a few DSS queries. During investigation, you execute the queries:
Based on the output, which two courses of action would you recommend to improve query performance? (Choose two.)
A. Use a parallel hint in the queries.
B. Increase the number of DBWn processes.
C. Increase the value of the SORT_AREA_SIZE initialization parameter.
D. Increase the size of the temporary tablespace or add a new temporary tablespace.
E. Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
F. Increase the size of the large pool.
Answer: CF
PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2