nerdexam
IBM

P2090-050 · Question #12

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

(28 responses)
  • A
    7% (2)
  • B
    11% (3)
  • C
    4% (1)
  • D
    79% (22)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice