Oracle
1Z0-054 · Question #115
1Z0-054 Question #115: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #115. The question stem and answer options stay visible for context.
Question
You are working on a single node database. The storage for the database was recently upgraded to new, faster hard disks and new disk controllers. You ran the I/O calibration procedure to check the I/O metrics for the upgraded storage. The details for the execution of the I/O calibration procedure are given below: SQL>DECLARE 2l_latency INTEGER; 3l_iops INTEGER; 4l_mbps INTEGER; 5 BEGIN 6dbms_resource_manager.calibrate_io (1,10,l_iops,l_mbps,l_latency); 7 END;/ You queried the DBA_RSRC_IO_CALIBRATE data dictionary view to check the results of the I/O calibration. The output for the query is given as follows: SQL> SELECT max_iops, max_mbps, max_pmbps, latency FROM DBA_RSRC_IO_CALIBRATE; MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY ---------- ---------- ---------- ---------- 137 12 6 64 What do you infer from the output?
Options
- AThe actual latency is 10 milliseconds for one disk.
- BThe maximum sustainable I/O for a single process is 12 MB per second.
- CThe system can sustain a maximum of 137 I/O operations per second with a throughput of 6 MB
- DThe system can sustain a maximum of 137 I/O operations per second with a throughput of 12 MB
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.