Which of the following is the syntax for creating an Index?

Database developer interview questions

(Continued from previous question...)

3. Which of the following is the syntax for creating an Index?

3. Which of the following is the syntax for creating an Index?
1. CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)
2. CREATE [UNIQUE] INDEX OF tbl_name (index_columns)
3. CREATE [UNIQUE] INDEX ON tbl_name (index_columns)
4. CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

(Continued on next question...)

Other Interview Questions

• Which of the following has the highest order of precedence?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Which of the following is the syntax for creating an Index?
• Which of the following is not a valid character datatype in SQL Server?
• Which of the following statements about SQL Server comments is false?
• Consider the following transaction code
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• Which of the following are not date parts?
• The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table
• Which one of the following must be specified in every DELETE statement?
• Which one of the following correctly selects rows from the table myTable that have null in column column1?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Which of the following commands is used to change the structure of table?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Which of the following is the syntax for creating an Index?
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• Which one of the following must be specified in every DELETE statement?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Which of the following commands is used to change the structure of table?