Quick Study For Oracle 1z0-064 Exam With Practice Questions

Money back guarantee of Oracle Database 12c: Performance Management and Tuning 1z0-064 exam is offered on the both products in case of a failure because the experts are confident about the quality and authenticity of the both products practice test software and PDF files. Save your time and money both and prepare Oracle Database 12c: Performance Management and Tuning 1z0-064 certification exam with the internationally recognized practice test software and PDF booklet. PDF files consist of Latest Oracle 1z0-064 exam questions that realy helps you in your acutal Oracle 1z0-064 exam.

Version: 9.0
Question: 1

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

Question: 2

Which three statements are true about the interpretation of an execution plan? (Choose three.)

A. The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.
B. The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.
C. A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.
D. An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.
E. A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.

Answer: BDE

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