Which two inferences can be definitely derived from thi…

Examine the query and its output:

Which two inferences can be definitely derived from this output?(Choose two.)

Examine the query and its output:

Which two inferences can be definitely derived from this output?(Choose two.)

A.
Thedb file scattered readevent has occurred 104 times in this session for file# 12.

B.
The session has completed performing a full table scan.

C.
The SQL statements in this session are performing excessive disk reads.

D.
The multiblock factor is 8 for this I/O but it could vary for the other I/O events.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


vasya

vasya

imo B and D

job

job

B is wrong. fast full index scan will cause this wait event if physical i/o is required. Did you guys above really passed the exam?

oracool

oracool

B, D.
The other 2 choices do not make sense. Performance Tuning Guide page 10-24 indicating full table scan could occur though rarely. Unfortunately, this question needs 2 answers.

odba

odba

hi,
Have you passes exam, answers in comment section of this exam are very contradictory. Please let me know answers which you have used in exam.