nerdexam
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)
  • A
    7% (2)
  • B
    11% (3)
  • C
    4% (1)
  • D
    79% (22)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice