nerdexam
IBM

C2090-610 · Question #100

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

The correct answer is D. Materialized Query Table. See the full explanation below for the reasoning.

Question

Which DB2 object can be used to improve the execution performance of qualified SELECT statements?

Options

  • ATrigger
  • BSQL Procedure
  • CSequence Object
  • DMaterialized Query Table

How the community answered

(44 responses)
  • A
    5% (2)
  • B
    14% (6)
  • C
    9% (4)
  • D
    73% (32)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice