Pass Oracle 1z0-064 Exam Easily With Questions And Answers PDF

VCE-Braindumps understands the importance of all key topics of Oracle Database 12c: Performance Management and Tuning 1z0-064 exam so that we prepare 1z0-064 exam dumps material is prepared according to the 1z0-064 exam pattern. You feel in the actual Oracle 1z0-064 exam confident enough to attempt each 1z0-064 exam question perfectly. Just check the 1z0-064 exam free demo first to have an idea what exactly VCE-Braindumps has prepared for you and offering with Money Back Guarantee!

Version: 9.0
Question: 1

You have been asked to use table compression for two large tables. Given are the details of the tables:
The TRANS_DET table:
The table is used by an OLTP application.
High volume insert and update operations are performed on the table.
The table is frequently queried using index range scans.
The TRANS_HISTORY table:
The table is used by a DSS application.
High volume bulk loads are performed on the table.
The table is used to store archival data on which large table full-table scans (FTS) are performed.
Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)

A. basic table compression for both the tables
B. advanced row compression for both the tables
C. basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET table
D. basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY table
E. warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table

Answer: A

Question: 2

Examine the partial Activity Over Time section of an Active Session History (ASH) report:

Which two inferences are correct? (Choose two.)

A. In the first time slot, five different sampled sessions were connected to the database instance.
B. In the second time slot, out of the nine sampled sessions connected to the database instance, only one sampled session was idle at the time of report generation.
C. In the first time slot, only one sampled session was using the CPU.
D. In the second time slot, five different sampled sessions were using the CPU.
E. In the second time slot, 0.14% of the time was spent on the CPU.

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