Oracle Database SQL — Question 2

Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)

Answer options

• A. INSERT can be granted only on tables and sequences.
• B. DELETE can be granted on tables, views, and sequences.
• C. SELECT can be granted on tables, views, and sequences.
• D. ALTER can be granted only on tables and sequences.
• E. REFERENCES can be granted only on tables.

Correct answer: C, D

Explanation

The correct answers are C and D because SELECT privileges can indeed be assigned to tables, views, and sequences, while the ALTER privilege is restricted to tables and sequences only. Options A, B, and E are incorrect as they misrepresent the scope of the respective privileges; for instance, DELETE cannot be granted on views or sequences, and REFERENCES is not limited to just tables.