Home » MCQs » SQLite MCQs

What is the syntax of CREATE UNIQUE INDEX statement?

85. What is the syntax of CREATE UNIQUE INDEX statement?

1. CREATE INDEX index_name ON table_name ( column1, column2,...columnN);
2. CREATE UNIQUE INDEX index_name AS table_name ( column1, column2,...columnN);
3. CREATE UNIQUE INDEX index_name ON table_name ( column_name COLLATE NOCASE );
4. CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

Answer: D) CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

Explanation:

The syntax of CREATE UNIQUE INDEX statement is:

CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);