Which two statements are true?

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.)

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.



Leave a Reply 0

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