Which of the following commands is used to chang

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

(Continued from previous question...)

13. Which of the following commands is used to change the structure of table?

13. Which of the following commands is used to change the structure of table?
1. CHANGE TABLE
2. MODIFY TABLE
3. ALTER TABLE
4. UPDATE TABLE

(Continued on next question...)

Other Job Interview Questions

• Which of the following is the syntax for creating an Index?
• Which one of the following correctly selects rows from the table myTable that have null in column column1?
• Which one of the following must be specified in every DELETE statement?
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• Consider the following transaction code
• When designing a database table, how do you avoid missing column values for non-primary key columns?
• 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 is not a valid character datatype in SQL Server?
• Which of the following constraints can be used to enforce the uniqueness of rows in a table?
• Which of the following is not a valid character datatype in SQL Server?
• More...