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
NEW QUESTION 73
You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report:
Which three statements are true in this scenario? (Choose three.)
A. Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.
B. The CPU is spending more time in finding cursors in the library cache.
C. Cursors are not getting shared, resulting in a large number of hard parses.
D. Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.
E. The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.
Answer: BCD
NEW QUESTION 74
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: BDE
NEW QUESTION 75
Which two statements are true about gathering statistics? (Choose two.)
A. If an application has only SQL statements with bind variables, it is better to drop existing histograms, disable creation of histograms, and allow the optimizer to select the best execution plans.
B. If end users query newly inserted data, it is possible to get a suboptimal execution plan even if the automatic statistics gathering job is enabled.
C. If concurrent statistics gathering is done by using parallel execution, the Resource Manager should be used for efficient resource management.
D. For each session that is accessing a global temporary table, the optimizer uses only the shared statistics.
Answer: AB
NEW QUESTION 76
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
NEW QUESTION 77
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. 5, 7
B. 2, 4, 3
C. 3, 4, 8
D. 4, 5, 7
E. 5, 1, 6, 8
Answer: E
NEW QUESTION 78
Which two situations can lead to sparsely populated index blocks? (Choose two.)
A. Data is frequently inserted using direct path load into a table with an index.
B. Indexed columns in a table are frequently updated.
C. Values in an indexed column are inserted using monotonically incrementing sequences.
D. Bulk delete operations are performed on a table with indexes.
E. Online table move operations are performed frequently on a table with indexes.
Answer: BD
NEW QUESTION 79
Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)
A. ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.
B. ADDM runs in Partial mode to analyze any hung database issues.
C. Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.
D. Real-Time ADDM is automatically invoked by ADDM at the end of every hour.
Answer: AC
NEW QUESTION 80
Examine the parameters set for a database instance:
The database supports a mixed workload. Users complain about the increased response time of a few DSS queries. During investigation, you execute the query:
Based on the output, which two are possible ways to improve the performance of the queries? (Choose two.)
A. Enable temporary undo.
B. Enable Automatic Memory Management.
C. Increase the number of DBWn processes.
D. Enable Automatic Shared Memory Management.
E. Increase the value of the SGA_TARGET parameter.
F. Increase the value of the PGA_AGGREGATE_TARGET parameter.
Answer: BF
NEW QUESTION 81
You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables. What is the recommended action to improve performance? (Choose the best answer.)
A. Increase the size of the undo tablespace and enable undo retention guarantee.
B. Increase the size of the database buffer cache.
C. Enable temporary undo.
D. Increase the size of the temporary tablespace or make it autoextensible.
E. Enable Automatic Segment Space Management (ASSM) for the undo tablespace.
Answer: C
Explanation:
https://docs.oracle.com/cd/B13789_01/server.101/b10739/undo.htm
NEW QUESTION 82
You are administering a database that supports an OLTP workload. An application performs a large number of small transactions. Users complain about increased response times for transactions. On investigation, you find that the cache hit ratio is 69%. Examine a partial output from V$SYSTEM_EVENT:
Which four can be possible reasons for the increased response time? (Choose four.)
A. The database buffer cache is inadequately sized.
B. DBWR is not writing the dirty buffers fast enough.
C. A large number of blocks are fetched from disks frequently.
D. Several full table scans are performed by transactions.
E. Blocks are aging out of the buffer cache frequently.
F. Many sessions are waiting for buffers that are currently being read into the buffer cache by other sessions.
Answer: ABEF
NEW QUESTION 83
……
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