Oracle
1Z0-071 · Question #122
1Z0-071 Question #122: Real Exam Question with Answer & Explanation
The correct answer is A. It can improve the performance of a large query by storing the result of a query block having the B. It enables sessions to reuse the same query block in a SELECT statement, if it occurs more than. See the full explanation below for the reasoning.
Question
Which two statements best describe the benefits of using the WITH clause? (Choose two.)
Options
- AIt can improve the performance of a large query by storing the result of a query block having the
- BIt enables sessions to reuse the same query block in a SELECT statement, if it occurs more than
- CIt enables sessions to store a query block permanently in memory and use it to create complex
- DIt enables sessions to store the results of a query permanently.
Community Discussion
No community discussion yet for this question.