Question

Which of the following commands is used to create an index on a table in SQLite?

a) CREATE INDEX

b) ADD INDEX

c) ALTER INDEX

d) MODIFY INDEX

Answer 1

Answer: a) CREATE INDEX

Explanation: The CREATE INDEX statement is used to create an index on a table in SQLite. The syntax is as follows: CREATE INDEX index_name ON table_name (column_name);