The syntax for creating an index is .
A) CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [, column2]);
B) CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]);
C) CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]);
D) CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]);

Question

Quizplus · Accepted Answer

The correct syntax for creating an index is "CREATE [UNIQUE] INDEX indexname ON tablename (column1 [, column2])". The keyword "UNIQUE" is optional, and "tablename" is used instead of "viewname". Option B matches this syntax and is therefore the correct answer.

The Syntax for Creating an Index Is