Oracle Database SQL — Question 204

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

Answer options

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

Correct answer: A, C, E

Explanation

The correct answers A, C, and E are accurate because UPDATE is limited to tables and views, SELECT is applicable to both tables and views, and REFERENCES is restricted to tables and views. Options B, D, and F are incorrect as DELETE can be granted on tables and views but not sequences, ALTER can be granted only on tables, and INSERT can be granted to tables and views, but sequences are not included.