HP
HP2-N36 · Question #42
Which statement is true about a query explain plan?
The correct answer is D. It displays the results of Optimizer to the user, showing projection(s) used and the query process. See the full explanation below for the reasoning.
Question
Which statement is true about a query explain plan?
Options
- AIt determines how to run the query, runs it, and returns the result.
- BIt writes the SQL to execute a query.
- CIt tells exactly how many rows will be returned by the query.
- DIt displays the results of Optimizer to the user, showing projection(s) used and the query process.
How the community answered
(28 responses)- A7% (2)
- B11% (3)
- C4% (1)
- D79% (22)
Community Discussion
No community discussion yet for this question.