Online Access Free 1z1-064 Exam Questions

Examine the partial PLAN_TABLE output:

Which is the correct sequence of execution? (Choose the best answer.)

• A.3, 2, 4, 1, 0
• B.3, 2, 4, 1, 0, 2
• C.0, 4, 1, 3, 2, 1
• D.0, 1, 2, 3, 4, 1
• E.3, 2, 1, 4, 0

Your database supports an OLTP workload during the day and batch processing at night. You want to monitor performance metrics to detect any degradation of performance in both types of workloads over a time period of 30 days.
Examine this list of possible steps:
1. Create a fixed baseline.
2. Create a baseline template.
3. Create a new moving window baseline.
4. Increase the retention period default value to 30 days.
5. Increase the size of the existing moving window baseline to 30 days.
6. Create warning and critical alerts for the relevant metrics.
7. Enable adaptive thresholds to detect the workload patterns and specify a high-significance-level threshold type.
8. Enable adaptive thresholds to detect the workload patterns and set different threshold values as a percentage of the maximum value.
Which option represents the required steps in the correct order? (Choose the best answer.)

• A.2, 4, 3
• B.5, 1, 6, 8
• C.4, 5, 7
• D.3, 4, 8
• E.5, 7

You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time.
Which two can be reasons for this? (Choose two.)

• A.Excessive time is spent on finding cached cursors in the library cache.
• B.Repeated access to a small number of blocks.
• C.The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.
• D.Bind variables are not used for similar queries, causing hard parses.
• E.The I/O performance is slow.

Which two are prerequisites for running the I/O calibration tool? (Choose two.)

• A.The database must be in MOUNT state.
• B.For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.
• C.The disks to be tested must be configured to use asynchronous I/O for data files.
• D.The database should be opened in restricted mode.
• E.The database instance must be started using an SPFILE.

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.
Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A.Oracle Enterprise Manager Cloud Control
• B.DBA_ALERT_HISTORY
• C.DBA_ACTIVE_SESSION_HISTORY
• D.DBA_OUTSTANDING_ALERTS
• E.the alert log
• F.DBA_THRESHOLDS