nerdexam
IBM

C2090-320 · Question #57

When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

The correct answer is D. CREATE TABLESPACE ... USING STOGROUP stogr1. See the full explanation below for the reasoning.

Question

When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

Options

  • ACREATE TRIGGER ...;
  • BCREATE TABLE ... IN db1.ts1;
  • CCREATE DATABASE ... STOGROUP stogr1;
  • DCREATE TABLESPACE ... USING STOGROUP stogr1;

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    7% (2)
  • C
    17% (5)
  • D
    73% (22)

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice