Which Three Object Privileges Apply to Tables, Views, and Sequences?
Which three are true about granting object privileges on tables, views, and sequences? (Choose three.)
Community Votes
100% of anonymous learners picked answer ADE. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
Tests knowledge of Oracle object privilege scope across tables, views, and sequences, with the trap being that SELECT is grantable on all three but is not an exclusive restriction.
Understand which object privileges can be granted on tables, views, and sequences in Oracle. This page explains why UPDATE, ALTER, and REFERENCES are the three correct statements, and why SELECT is not among them.
Many learners choose SELECT because it is valid on tables and views, but SELECT is also grantable on sequences, so it does not fit the exclusive 'only' pattern of the correct answers.
Community Discussion (4 comments)
- UPDATE can be granted only on tables and views - ALTER is valid for tables and sequences but not views. - REFERENCES can be granted only on tables and views.
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The correct answer is A, D, E. In Oracle, object privileges are scoped to specific object types. UPDATE can be granted on tables and views, but not on sequences, so A is true. ALTER is a valid object privilege for tables and sequences, but not for views, making D true. REFERENCES can be granted on tables and views to allow foreign key references, but it is not available for sequences, so E is true.
Why the Other Options Are Wrong
Option B is false because DELETE can only be granted on tables and views; sequences do not support DELETE privileges. Option C, while factually noting that SELECT can be granted on tables and views, is not one of the three correct answers because it is incomplete: SELECT is also grantable on sequences, and the question asks for true statements about privileges across all three object types. In the exam's wording, the intended distractor likely carried the implied 'only' restriction, which would make it false. Thus, C is not selected.
Community Comment Notes
Community discussion largely aligns with A, D, E. As Thameur01 explained, "UPDATE can be granted only on tables and views" and "ALTER is valid for tables and sequences but not views." bca123 noted that "Select can be given to all," which correctly identifies why C is not exclusive, though they still chose ADE. ArslanAltaf suggested "ACE is correct," but this minority view overlooks that ALTER is indeed grantable on sequences, making D true. Misi_Oracle's comment about ALTER being a system privilege is a misconception, as ALTER is also an object privilege on tables and sequences.
Official Reference
Exam Strategy
When a question asks for exactly three true statements, look for the options with the word 'only'—they often describe precise restrictions. Verify each privilege against Oracle's object privilege matrix, and be wary of statements that are partially true but omit an object type, as they may not be the intended correct answers.
Frequently Asked Questions
Why is SELECT not one of the correct answers even though it can be granted on tables and views?
SELECT is also grantable on sequences, so it does not represent an exclusive restriction like the correct options A, D, and E.
Can DELETE be granted on sequences?
No, DELETE is only valid on tables and views; sequences do not support DELETE object privileges.