Try Updated Oracle 1z0-064 Exam Questions – [Nov-2017 Dumps]
The success in Oracle Database 12c: Performance Management and Tuning 1z0-064 certification exam is very easy . Your success will give you a lot more in form of your professional development in Database Administrations,database performance management and Oracle Database 12c. The Oracle 1z0-064 exam practice test software comes with money back guarantee, if you fail in the 1z0-064 exam, you will not be at risk of losing your money at all. We at, CCNABraindumps provide you most latest and actual 1z0-064 exam questions.
You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)
A. Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.
B. Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.
C. Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.
D. Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.
Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events:
Identify three possible reasons for the increased response time. (Choose three.)
A. too many sort operations being performed
B. repeated simultaneous access to a block or small number of blocks
C. the shared pool is inadequately sized
D. queries not using indexes and performing full table scans
E. queries repeatedly fetching blocks that are not in the database buffer cache
F. cursors are closed explicitly after each execution
Answer: B, D, E
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.
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