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 55
You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high. Which two can be possible resolutions for this issue? (Choose two.)
A. Increase the size of the large pool.
B. Increase the value of the PGA_AGGREGATE_TARGET parameter.
C. Create a temporary tablespace group and assign it to users.
D. Increase the value of the PGA_AGGREGATE_LIMIT parameter.
E. Create another temporary tablespace and assign it to users.
F. Enable temporary undo.
Answer: BC
QUESTION 56
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 57
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.
Answer: C
QUESTION 58
Examine the parameters set for a database instance:
An application performs a large number of identical queries on small lookup tables very frequently. Users complain about the slow response time of queries on these tables. On investigation, you notice that buffers are getting aged out of the buffer cache. To mitigate the issue, you increase the value of the SGA_MAX_SIZE and SGA_TARGET parameters, but after some time, you notice the same issue again. Which two would you recommend as long-term solutions for this issue? (Choose two.)
A. increasing the size of the database buffer cache
B. configuring Automatic Memory Management
C. configuring the KEEP buffer pool and altering tables to use the KEEP pool
D. pinning the cursors of the queries in the library cache
E. configuring the result cache for the instance
Answer: AB
QUESTION 59
Which two statements are true about ADDM? (Choose two.)
A. It analyzes the performance of a database instance based on the time period covered by the most recent AWR snapshot, and generates recommendations based on hard-coded criteria.
B. It can analyze performance issues that occurred in past events provided they fall within the AWR retention period.
C. ADDM resource utilization and cost of analysis depends on the actual load on the database and the number of performance problems analyzed.
D. It first identifies the performance symptoms, and then refines them to reach the root cause with the singular aim of reducing the DB CPU metric.
E. It documents only those components and wait classes that are significantly impacting the performance of the database.
Answer: AB
QUESTION 60
Which two are prerequisites for running the I/O calibration tool? (Choose two.)
A. The database must be in MOUNT state.
B. The database should be opened in restricted mode.
C. For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.
D. The disks to be tested must be configured to use asynchronous I/O for data files.
E. The database instance must be started using an SPFILE.
Answer: CD
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