Oracle
1Z0-064 · Question #54
Examine the query and its output: Which two inferences can be definitely derived from this output? (Choose two.)
The correct answer is A. The db file scattered read event has occurred 104 times in this session for file# 12. C. The SQL statements in this session are performing excessive disk reads. See the full explanation below for the reasoning.
Question
Examine the query and its output:
Which two inferences can be definitely derived from this output? (Choose two.)
Exhibit
Options
- AThe db file scattered read event has occurred 104 times in this session for file# 12.
- BThe session has completed performing a full table scan.
- CThe SQL statements in this session are performing excessive disk reads.
- DThe multiblock factor is 8 for this I/O but it could vary for the other I/O events.
How the community answered
(32 responses)- A78% (25)
- B6% (2)
- D16% (5)
Community Discussion
No community discussion yet for this question.