Which two statements are true?

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

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.



Leave a Reply 3

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


Larisa

Larisa

So the second execution of the query is the one with child_number 0 ? This seems counterintuitive