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.
imo B and D
B,D
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?
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.
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.
https://docs.oracle.com/cd/E11882_01/server.112/e41573/instance_tune.htm#PFGRF94479
A dummy
B Not only FTS generate this event (FTS should often lead to Direct read now)
C is right
D also : see event definition
A,B
https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3023.htm