Question

We delete and index in SQL using the ________ command

(a) Remove index

(b) Delete index

(c) Drop index

(d) None of the mentioned

The question was posed to me in class test.

The above asked question is from Bitmap Indices in division Indexing and Hashing of RDBMS

Answer 1

Right choice is (c) Drop index

The best I can explain: We delete and index in SQL using the drop index command. Syntax: drop index ;