Oracle
1Z0-064 · Question #19
1Z0-064 Question #19: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-064 to reveal the answer and full explanation for question #19. The question stem and answer options stay visible for context.
Question
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.)
Exhibits
Options
- ANo statistics were collected during the first execution of the query.
- BA subsequent execution of the query in this session is likely to undergo a soft parse.
- CThe second execution of the query was hard parsed because the estimated cardinality was
- DA subsequent execution of the query in this session will undergo a hard parse.
- EThe second execution of the query was hard parsed because extended statistics were collected
Unlock 1Z0-064 to see the answer
You've previewed enough free 1Z0-064 questions. Unlock 1Z0-064 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.