nerdexam
IBM

C2090-600 · Question #10

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

The correct answer is A. To prune the contents of a staging table. See the full explanation below for the reasoning.

Question

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

Options

  • ATo prune the contents of a staging table.
  • BTo prune the contents of a synopsis table.
  • CTo prune the contents of a materialized query table (MQT).
  • DTo prune the contents of a declared global temporary table.

How the community answered

(37 responses)
  • A
    70% (26)
  • B
    8% (3)
  • C
    3% (1)
  • D
    19% (7)

Community Discussion

No community discussion yet for this question.

Full C2090-600 Practice