Home » MCQs » SQLite MCQs

What is the syntax of CREATE INDEX statement?

84. What is the syntax of CREATE INDEX statement?

1. CREATE INDEX index_name OF table_name ( column_name COLLATE NOCASE );
2. CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );
3. CREATE INDEX index_name AT table_name ( column_name COLLATE NOCASE );
4. CREATE INDEX index_name AS table_name ( column_name COLLATE NOCASE );

Answer: B) CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );

Explanation:

The syntax of CREATE INDEX statement is CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );.