PrepAway - Latest Free Exam Questions & Answers

What is the lowest privilege/authority required to execute the following SQL statement?

What is the lowest privilege/authority required to execute the following SQL statement?
CREATE VIEW view1 AS SELECT * FROM table1 WHERE AGE > 18

PrepAway - Latest Free Exam Questions & Answers

A.
REFERENCES privilege on table1

B.
SELECT privilege on table1

C.
DBADM authority

D.
SYSADM authority

Explanation:


Leave a Reply