Question 38


Answer D is correct. You can use an INSTEAD OF TRigger to perform a different action than what was originally intended. INSTEAD OF TRiggers are executed in place of the usual triggering action. INSTEAD OF TRiggers can also be defined on views with one or more base tables, where they can extend the types of updates a view can support.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Designing and Creating Databases, DML Triggers, Understanding DML Triggers, Types of DML Triggers"

  • "Enforcing Business Rules with Triggers," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_08_116g.asp




MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net