IBM
C2090-610 · Question #8
Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?
The correct answer is D. SELECT privilege on TAB1 and TAB2. See the full explanation below for the reasoning.
Question
Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?
Options
- ACREATEIN privilege on the database
- BREFERENCES privilege on TAB1 and TAB2
- CCREATE_TAB privilege on the database
- DSELECT privilege on TAB1 and TAB2
How the community answered
(38 responses)- A13% (5)
- B5% (2)
- C8% (3)
- D74% (28)
Community Discussion
No community discussion yet for this question.