Which Three Object Privileges Apply to Tables, Views, and Sequences?

1Z0-071 By islever Editorial Last updated

Granting privileges on tables System privileges versus object privileges

Short answer

ADE UPDATE is valid on tables and views, ALTER on tables and sequences, and REFERENCES on tables and views only.

Question

Which three are true about granting object privileges on tables, views, and sequences? (Choose three.)
  1. UPDATE can be granted only on tables and views. Correct Answer
  2. DELETE can be granted on tables, views, and sequences.
  3. SELECT can be granted on tables and views.
  4. ALTER can be granted only on tables and sequences. Correct Answer
  5. REFERENCES can be granted only on tables and views. Correct Answer

Key Takeaways

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.

Common mistake: 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.

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

These links open the official vendor documentation in a new tab.

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.

More 1Z0-071 FAQ →

Community Votes

ADE
100%

100% of anonymous learners picked answer ADE. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. Misi_Oracle 👍 2
    A. TRUE B. FALSE. Only Table C. True. Can also be granted on sequences D. False. Trick question as alter is system privilege. Alter can be granted on both table and sequences. E. TRUE F. False. Insert can be granted to table and synonym
  2. Thameur01 👍 1
    - 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.
  3. bca123 👍 1
    Select can be given to all.
  4. ArslanAltaf 👍 1
    ACE is correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

System and Object Privileges in Oracle Database

S-grade

Which Three Actions Can Be Performed Only With System Privileges?

S-grade

How Do You Calculate Days from 1 Jan 2019 to SYSDATE in Oracle?

S-grade

Which Two SQL Statements Execute on TRANSACTIONS Table?

S-grade

← Back to 1Z0-071 Study Guide