The Syntax for Creating an Index Is

question 9

Multiple Choice

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]);