Oracle Database 12c: Performance Management and Tuning 1z0-064 Certification exam is also known as Oracle Database 12c: Performance Management and Tuning exam. With the updated 1z0-064 exam questions and answers, TestsLeader has assembled to take you through 84 Q&As to prepare you for your 1z0-064 Exam. In the 1z0-064 exam dumps, you will cover all the essentials of Oracle Database 12c: Performance Management and Tuning 1z0-064 exam, which will make you successful in 1z0-064 Oracle Certification Exam.
You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database. You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimized version.
Which two methods would you use to achieve this? (Choose two.)
A. Create an SQL Tuning Set (STS) for the SQL statements in the production database and submit as input to the SQL Tuning Advisor on the test database.
B. Create an STS for the SQL statements in the production database and submit as input to the SQL Performance Analyzer with the OPTIMIZER_FEATURES_ENABLE parameter first set to 18.104.22.168, and then to 22.214.171.124 on the test database.
C. Generate an Automatic Workload Repository (AWR) compare periods report with snapshots taken before and after schema changes on the test database.
D. Capture the production database workload, replay it on the test system by using Database Replay, and analyzed by using the workload replay compare period report.
E. Create an STS for the SQL statements in the production database and submit as input to the SQL Access Advisor on the test database.
F. Create an STS for the SQL statements on the production database before and after changes and submit as input to the SQL Performance Analyzer on the test database.
Answer: A, D
You recently joined a new team administering a database. You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job. You decide that performance problems are caused by a misconfiguration of factors affecting full table scans. Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
A. value of DB_FILE_MULTIBLOCK_READ_COUNT
B. storing query results in the result cache
C. setting of the DISK_ASYNC_IO parameter to TRUE
D. setting of the OPTIMIZER_MODE parameter to ALL_ROWS
E. use of parallel queries
F. block size of the tablespaces in which the tables being scanned are stored
G. value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
Answer: A, B, C
New Updated 1z0-064 Exam Questions 1z0-064 PDF dumps 1z0-064 practice exam dumps: https://www.dumpsschool.com/1z0-064-exam-dumps.html (84 Questions)
In your database, the measured 99th percentile value is used as the maximum value. You set a warning threshold level of 110% of the maximum trigger as an alert. What is the outcome? (Choose the best answer.)
A. It generates an error because the warning threshold cannot exceed 100%.
B. It generates an error because the percentage of the maximum threshold cannot be set with a significance-level threshold value.
C. It generates an alert when an observed metric is 99% of the 99th percentile value as measured over the moving window baseline.
D. It generates an alert when an observed metric is 110% of the 99th percentile value as measured over the moving window baseline.
E. It generates an alert when 1 in 100 observations for an observed metric exceeds the 99th percentile value as measured over the fixed baseline.
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.)
A. Create AWR baselines.
B. Create SQL plan baselines.
C. Create repeating baseline templates.
D. Create database services and make sure that user connections use them to connect to the database instance.
E. Create a single baseline template.
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.)
A. setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
B. coding the application such that a frequently executed statement is parsed only once and executed repeatedly as required
C. setting the CURSOR_SHARING parameter to EXACT
D. avoiding the granting of privileges on objects associated with cursors during peak load
E. enabling Automatic Memory Management and allocating at least 50% of the available memory for SHARED_POOL_SIZE
F. configuring shared server connections
Answer: B, E
You are administering a database that supports multiple applications, which make dedicated connections to the database instance by using different services.
You execute the command to enable tracing of the ORCL1 service:
Which two statements are true? (Choose two.)
A. A single trace file is generated for all sessions mapped to the ORCL1 service.
B. SQL trace is enabled for all modules and actions for sessions mapped to the ORCL1 service.
C. An SQL trace file is generated for each session that maps to the ORCL1 service.
D. An SQL trace file is generated for each of the modules using the ORCL1 service.
E. SQL trace is not enabled for the service because a module name is not specified.
Answer: A, C