What Is The Syntax Of Create Index Statement #84
What is the syntax of CREATE INDEX statement?
This multiple choice question (MCQ) is related to the book/course gs gs118 Data Mining. It can also be found in gs gs118 SQLite MCQs - SQLite MCQs - Quiz No.9.
What is the syntax of CREATE INDEX statement?
CREATE INDEX index_name OF table_name ( column_name COLLATE NOCASE );
CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );
CREATE INDEX index_name AT table_name ( column_name COLLATE NOCASE );
CREATE INDEX index_name AS table_name ( column_name COLLATE NOCASE );