Try 1z0-064 Oracle Exam Questions – (Nov-2017 Dumps)

Oracle Database 12c: Performance Management and Tuning 1z0-064 Certification exam is an excellent opportunity for the professionals for taking their professional life to the next level. The Oracle 1z0-064 exam dumps material provide you latest 1z0-064 exam questions that are like real 1z0-064 exam. PracticeTestsGuru’s Oracle 1z0-064 Certification exam dumps preparation package which consist of practice test software and PDF Q&A file , which is available at the most reasonable price. The Oracle 1z0-064 exam questions are designed for the candidates already doing job and they are expected to have some real world experience.

Version: 9.0
Question: 1

Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)

A. Use the Resource Manager.
B. Enable SQL Trace at the session level.
C. Create a service.
D. Use a dedicated server configuration.
E. Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.

Answer: BE

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

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: B, E

Question: 3

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

Answer: A

Question: 4

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.

Answer: D

Question: 5

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

Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm
Question: 6

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

Facebook Comments