Thursday, June 7, 2007

Question 34

The measurement results shown below were obtained when a certain SQL statement was processed. Based on the results, it seems there is some waiting for resources. What is the total waiting time in seconds? In this example, communication/processing time can be ignored.

CPU time 200 milliseconds
Response time 35.0 seconds
Physical I/O processing 400 operations
Average disk access time per physical
I/O processing
15 milliseconds
(including search time)
Logical I/O processing 2,000 operations

a) 4.8
b) 6.2
c) 28.8
d) 29.0


No comments: