Oracle Database SQL — Question 85

Which two object privileges can be restricted to a subset of columns in a table? (Choose two.)

Answer options

• A. INDEX
• B. ALTER
• C. UPDATE
• D. INSERT
• E. DELETE

Correct answer: C, D

Explanation

The correct answers, C (UPDATE) and D (INSERT), are both privileges that can be allocated to specific columns in a table, allowing for more granular control over data access. The other options, A (INDEX), B (ALTER), and E (DELETE), do not support column-level restrictions as they apply to the table as a whole or do not relate to data modification directly.