Multiple choice technology databases

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

  1. GRANT DROP ON INDEX empid_x TO user1

  2. GRANT DELETE ON INDEX empid_x TO user1

  3. GRANT INDEX ON TABLE employee TO user1

  4. GRANT CONTROL ON INDEX empid_x TO user1
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To drop an index in DB2, a user must have CONTROL privilege on the index (or table) or administrative authority. Granting CONTROL on the index specifically provides this administrative right. The INDEX privilege on a table only allows creating new indexes, not dropping existing ones.

Keep practicing — related questions