IBM

C2090-610 · Question #42

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

The correct answer is A. REVOKE USE OF TABLESPACE mytbsp FROM user1. See the full explanation below for the reasoning.

Question

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

Options

AREVOKE USE OF TABLESPACE mytbsp FROM user1
BREVOKE ALTER ON TABLESPACE mytbsp FROM user1
CREVOKE UPDATE OF TABLESPACE mytbsp FROM user1
DREVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

How the community answered

(27 responses)

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

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-610 Practice