Which of the following is the syntax for creatin

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• Which of the following statements about SQL Server comments is false?
• Which one of the following must be specified in every DELETE statement?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Which of the following is not a valid character datatype in SQL Server?
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• Which of the following is not a valid character datatype in SQL Server?
• Which of the following has the highest order of precedence?
• Which one of the following must be specified in every DELETE statement?
• More...