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]) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q5: The SQL data manipulation command HAVING:<br>A) restricts
Q10: Which of the following queries will list
Q12: The special operator is used to check
Q14: A database language enables the user to
Q36: A(n)is performed when data are retrieved from
Q44: Date procedures are often more software-specific than
Q48: Which of the following queries will use
Q53: The special operator used to check whether
Q60: The special operator used to check whether
Q69: In a 1:M relationship, a user must