Which command will create an index?
A) CREATE INDEX indexname IN tablename (columnname)
B) CREATE INDEX indexname REFERENCE (columnname)
C) CREATE INDEX indexname ON tablename (columnname)
D) CREATE INDEX indexname INCREMENT BY (columnname)

Question

​Which command will create an index?
A) ​CREATE INDEX indexname IN tablename (columnname)
B) ​CREATE INDEX indexname REFERENCE (columnname)
C) ​CREATE INDEX indexname ON tablename (columnname)
D) ​CREATE INDEX indexname INCREMENT BY (columnname)

Quizplus · Accepted Answer

The correct syntax for creating an index in SQL is "CREATE INDEX indexname ON tablename (columnname)". Option A is close but the "IN" keyword is not required. Option B is incorrect as there is no "REFERENCE" keyword in the syntax. Option D is incorrect because "INCREMENT BY" is not used for creating indexes.

​Which Command Will Create an Index

Which Command Will Create an Index