nerdexam
IBM

C2090-610 · Question #17

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

The correct answer is A. GRANT ALTER ON SEQUENCE myseq TO user1. See the full explanation below for the reasoning.

Question

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

Options

  • AGRANT ALTER ON SEQUENCE myseq TO user1
  • BGRANT USAGE ON SEQUENCE myseq TO user1
  • CGRANT SELECT ON SEQUENCE myseq TO user1
  • DGRANT COMMENT ON SEQUENCE myseq TO user1

How the community answered

(28 responses)
  • A
    82% (23)
  • B
    4% (1)
  • C
    4% (1)
  • D
    11% (3)

Community Discussion

No community discussion yet for this question.

Full C2090-610 Practice