Question

Which of the following is true about SQLite indexes?

a) An index is used to speed up data retrieval from a table.

b) An index is created on one or more columns of a table.

c) An index can be created using the CREATE INDEX statement.

d) All of the above.

Answer 1

Answer: d) All of the above.

Explanation: An index is used to speed up data retrieval from a table, and it is created on one or more columns of a table. An index can be created using the CREATE INDEX statement.