nerdexam
IBM

A2090-560 · Question #104

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

The correct answer is D. GRANT SELECT ON TableA TO UserA. See the full explanation below for the reasoning.

Question

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

Options

  • ADROP TABLE TableA
  • BALTER TABLE TableA
  • CTRUNCATE TABLE TableA
  • DGRANT SELECT ON TableA TO UserA

How the community answered

(27 responses)
  • A
    15% (4)
  • B
    7% (2)
  • C
    4% (1)
  • D
    74% (20)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice