What does Trigger refers to in MS SQL Server?

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

(Continued from previous question...)

What does Trigger refers to in MS SQL Server?

Trigger MS SQL Server refers to a Stored Procedure that is invoked automatically when a predefined event occurs.
A predefined event could be an execution of INSERT, UPDATE, or DELETE statement at the row level, or at the statement level.

(Continued on next question...)

Other Job Interview Questions

• What does RDBMS stand for?
• What is the purpose of IAM (Index Allocation Map) in MS SQL Server?
• What does RDBMS stand for?
• What is the main purpose of assigning a user with the "processadmin" role?
• What can you do with the "BULK INSERT" T-SQL command in MS SQL Server?
• What two categories you can divide T-SQL statements into?
• What is the meaning of the following T-SQL command: DBCC SHRINKDATABASE ( Database, 10%)
• What is the meaning of Data Normalization?
• What is the difference between a "User DSN" and a "System DSN" ODBC connection?
• What is a Torn Page in MS SQL Server?
• More...