We provide real 1z0-054 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1z0-054 Exam quickly & easily. The 1z0-054 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1z0-054 dumps pdf and vce product and material, you can easily pass the 1z0-054 exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-054 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q21. You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of hardware failure. When the disk is added back again after the fix, because the database is active, rebalance operations impact the I/O subsystem.
Which two recommendations would you give to lower the impact on the I/O subsystem? (Choose two.)
A. Increase the number of ASMB processes.
B. Increase the number of DBWR_IO_SLAVES.
C. Decrease the value for the ASM_POWER_LIMIT parameter.
D. Increase the value for the ASM_POWER_LIMIT parameter.
E. Set the DISK_REPAIR_TIME disk attribute to a lower value.
F. Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.
Q22. As a DBA, you notice a change in the performance of your database.
Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Choose two.)
A. the number of block corruption errors
B. SQL statements that are consuming maximum resources
C. the top five sessions that are consuming maximum resources
D. the instance parameter values that have been changed using ALTER SYSTEM since the last baseline
Q23. View the Exhibit that shows your investigation on degraded performance.What would you do? (Choose all that apply.)
A. Shrink the temporary segment.
B. Keep the large tables in the KEEP pool.
C. Use free list groups wherever applicable.
D. Increase the value set to the PGA_AGGREGATE_TARGET parameter.
E. Switch the segments to Automatic Segment Space Management (ASSM).
Q24. You noticed a high number of SQL statements with the same PLAN_HASH_VALUES.
View Exhibit1 to see the details.
View Exhibit2 to see the details of the SQL text for the statements.
What do you infer from the results?
A. The statements are using the same cursor.
B. The statements are not using the same cursor.
C. Removing the bind variable would improve performance.
D. The cursor for the statement is aging out of the shared pool very quickly.
Q25. The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.
What would you suggest to analyze this performance problem for the user?
A. SQL Tuning Advisor
B. SQL Performance Analyzer
C. Active Session History report
D. AWR Compare Periods report
Q26. While diagnosing performance problems for a database, you find Buffer Busy wait is the reason from V$ views. But the Automatic Database Diagnostic Monitor (ADDM) report does not reflect the Buffer Busy findings.
Why does the Buffer Busy finding not appear in the ADDM report?
A. because an ADDM filter has been set
B. because the he USE_INDIRECT_DATA_BUFFERS parameter has been set to TRUE
C. because the DBIO_EXPECTED default task parameter for ADDM has been set to zero
D. because the CONTROL_MANAGEMENT_PACK_ACCESS parameter has been set to DIAGNOSTIC
Q27. View Exhibit1 and examine a portion of Active Session History(ASH) report.
View Exhibit2 to examine the tablespaces.
Which action would you suggest after analyzing the output?
A. Increase the log buffer size.
B. Rebuild indexes on SPCT table.
C. Decreasing the number of free lists in segment SPCT.
D. Move SPCT table to a different tablespace that is locally managed with automatic segment space management.
Q28. The OS administrator in your company informed you about the upgrade of storage to new disk controllers and hard disks. You want to test if the new I/O devices are capable of handling the I/O load. The database is using Automatic Storage Management(ASM) for storage. To test the throughput and other I/O metrics, you performed IO calibration from the Enterprise Manager but you notice that the IO calibration job failed. To see the details of the error, view the Exhibit.
How you can resolve the error?
A. Set FILESYSTEMIO_OPTIONS to NONE and DISK_ASYNCH_IO to FALSE.
B. Set FILESYSTEMIO_OPTIONS to SYNCH and DISK_ASYNCH_IO to FALSE.
C. Set FILESYSTEMIO_OPTIONS to ASYNCH and DISK_ASYNCH_IO to TRUE.
D. Set FILESYSTEMIO_OPTIONS to DIRECTIO and DISK_ASYNCH_IO
Q29. You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test the performance SQL on the upgraded database. You want to build the before-change performance data by using SQL Performance Analyzer.
Which method would allow the task to execute quickly?
A. the EXPLAIN PLAN method
B. the TEST EXECUTE method
C. the COMPARE PERFORMANCE method
D. the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE
Q30. You work on an online transaction processing (OLTP) database in which the SALES table has 10,000 rows but only four distinct products are sold. View the Exhibit named HIST to check data distribution in the table and the histograms on the table.
View the Exhibit named QUERY-1 that shows details in the V$SQL view for the query executed on the SALES table having product id 1.
Further, you query the SALES table thrice more in the following order:
- query rows having product ID 4
- query rows having product ID 2
- query rows having product ID 4
View the Exhibit named QUERY-n to see the details about these queries.
What do you infer from this?
A. The second plan was created because the first plan was aged out.
B. The CURSOR_SHARING parameter value was changed to EXACT after the second query was executed.
C. The third plan was created because the first plan was aged out and the second plan had different selectivity.
D. The first two executions used the same plan because at parse time the optimizer did not consider selectivity as the cursor was not yet considered bind-aware.