PrepAway - Latest Free Exam Questions & Answers

which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and

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?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATEIN privilege on the database

B.
REFERENCES privilege on TAB1 and TAB2

C.
CREATE_TAB privilege on the database

D.
SELECT privilege on TAB1 and TAB2

One Comment on “which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and


Leave a Reply