Oracle
1Z0-047 · Question #15
Which two statements best describe the benefits of using the WITH clause? (Choose two.)
The correct answer is C. It enables users to reuse the same query block in a SELECT statement, if it occurs more than once in D. It can improve the performance of a large query by storing the result of a query block having the WITH. 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 enables users to store the results of a query permanently.
- BIt enables users to store the query block permanently in the memory and use it to create complex queries.
- CIt enables users to reuse the same query block in a SELECT statement, if it occurs more than once in
- DIt can improve the performance of a large query by storing the result of a query block having the WITH
How the community answered
(67 responses)- A9% (6)
- B13% (9)
- C78% (52)
Community Discussion
No community discussion yet for this question.