nerdexam
IBM

C2090-320 · Question #70

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

The correct answer is D. EXECUTE. See the full explanation below for the reasoning.

Question

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

Options

  • ABIND
  • BREORG
  • CTRIGGER
  • DEXECUTE

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    11% (4)
  • C
    9% (3)
  • D
    77% (27)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice