Multiple choice technology databases

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

  1. GRANT ALTER ON TABLE department TO user1

  2. GRANT ALTER (dept_name) ON TABLE department TO user1

  3. GRANT UPDATE ON TABLE department TO user1

  4. GRANT UPDATE (dept_name) ON TABLE department TO user1
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Specifying column names within parentheses after the UPDATE keyword restricts the update privilege strictly to the named columns. A generic UPDATE privilege allows modifications to all columns in the table, whereas the ALTER privilege is meant for structural changes rather than changing existing table data.

Keep practicing — related questions