During a BULK INSERT operation, are triggers and

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

(Continued from previous question...)

During a BULK INSERT operation, are triggers and contraints enforced by default?

No. During a BULK INSERT operation, only default and datatype rules are enforced while inserting rows.
Triggers, contraints and other additional rules are not enforced by default.

(Continued on next question...)

Other Job Interview Questions

• What is a Torn Page in MS SQL Server?
• What does Constraint refer to in MS SQL Server?
• When revoking one security role from a user, does it affect other security roles granted to same user?
• What is the fully qualified naming convention to specify a table in a linked Oracle database from MS SQL server?
• What is the meaning of the following T-SQL command: SELECT TOP 10 * FROM user WHERE last_name = 'Johnson'
• What does Trigger refers to in MS SQL Server?
• Is it true that MS SQL Server is sharing work load between the server and client computers?
• What is the meaning of the following T-SQL command: EXEC sp_dboption 'OrderDB', 'single user', 'true'
• What is the meaning of an Outer Join operatin of two tables?
• What is an Index in MS SQL Server?
• More...