Which object privileges can be granted on a view?
A. none
B. DELETE, INSERT,SELECT
C. ALTER, DELETE, INSERT, SELECT
D. DELETE, INSERT, SELECT, UPDATE
Correct Answer: D
Explanation/Reference:
Explanation:
Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE.
Incorrect answer:
AObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
BObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
CObject privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-12
Download Printable PDF. VALID exam to help you PASS.
|
|