You execute this query twice in a session:
Then you query V$SQL_SHARED_CURSOR for 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 thefirst execution of the query.