nerdexam
IBM

A2090-614 · Question #74

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

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

Question

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

Options

  • AEXPLAIN_FROM_DATA
  • BEXPLAIN_FROM_ACTIVITY
  • CEXPLAIN_FROM_SECTION
  • DEXPLAIN_FROM_CATALOG

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    4% (1)
  • C
    84% (21)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice