nerdexam
HP

HP2-N36 · Question #45

What can be used to determine memory resources needed by a query?

The correct answer is C. PROFILE the query. See the full explanation below for the reasoning.

Question

What can be used to determine memory resources needed by a query?

Options

  • AGenerate an EXPLAIN plan on the query.
  • BReview the digraph of the query.
  • CPROFILE the query.
  • DRun the query and view the information in the results.

How the community answered

(20 responses)
  • A
    5% (1)
  • C
    85% (17)
  • D
    10% (2)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice