Which one of the following must be specified in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

10. Which one of the following must be specified in every DELETE statement?

10. Which one of the following must be specified in every DELETE statement?
1. Table Name
2. Database name
3. LIMIT clause
4. WHERE clause
5. Column Names

(Continued on next question...)

Other Job Interview Questions

• Which of the following is not a valid character datatype in SQL Server?
• 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 of the following are not date parts?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• Which of the following statements about SQL Server comments is false?
• 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 one of the following must be specified in every DELETE statement?
• Which of the following is the syntax for creating an Index?
• Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
• More...