You execute this query twice in a session:
Then you queryV$SQL_SHARED_CURSORfor details about child cursors as shown.
Which two statements are true?(Choose two.)
A.
No statistics were collected during the first execution of the query.
B.
A subsequent execution of the query in this session is likely to undergo a soft parse.
C.
The second execution of the query was hard parsed because the estimated cardinality was
inaccurate.
D.
A subsequent execution of the query in this session will undergo a hard parse.
E.
The second execution of the query was hard parsed because extended statistics were
collected after the first execution of the query.
B,C
BC
So the second execution of the query is the one with child_number 0 ? This seems counterintuitive