IBM

C2090-610 · Question #21

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

The correct answer is B. GRANT SELECT ON TABLE employee TO user1. See the full explanation below for the reasoning.

Question

Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

Options

AGRANT CREATETAB ON DATABASE TO user1
BGRANT SELECT ON TABLE employee TO user1
CGRANT CREATEVIEW ON DATABASE TO user1
DGRANT REFERENCES ON TABLE employee TO user1

How the community answered

(50 responses)

A
4% (2)
B
82% (41)
C
10% (5)
D
4% (2)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-610 Practice