nerdexam
IBM

P2090-050 · Question #21

What will prevent a GROOM TABLE command from running on a table named TableA?

The correct answer is A. If there are any materialized views on the table TableA. See the full explanation below for the reasoning.

Question

What will prevent a GROOM TABLE command from running on a table named TableA?

Options

  • AIf there are any materialized views on the table TableA.
  • BIf there are any active selects running against the table TableA.
  • CIf there are any active nzloads running against the table TableA.
  • DIf there are any active updates running against the table TableA.

How the community answered

(34 responses)
  • A
    85% (29)
  • B
    6% (2)
  • C
    3% (1)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice