70-431 Microsoft SQL Server 2005 - Implementation and Maintenance Practice Tests

Demo Question 4.

EliteCertify.com as employed you as a database administrator. The EliteCertify.com network consists of a single Active Directory domain named EliteCertify.com. The EliteCertify.com network contains a SQL Server 2005 database named EliteCertify -DB06 EliteCertify -DB06 consists of a trigger named trg_InsertOrders. The trigger fires when order data is inserted into the Orders table. The trigger ensures that a client exists in the Customers table prior to the information being inserted into the Orders table. You have received instruction from the CIO to configure the trigger to prevent it from firing during the information import process. You need to accomplish this using the minimum of administrative effort. Which Transact-SQL statements should you use? (Choose all that apply)

A. You should use the statement sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'.
B. You should use the statement ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders Transact-SQL.
C. You should use the statement ALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATION Transact-SQL.
D. You should use the statement DROP TRIGGER trg_InsertOrders Transact-SQL.
E. You should use the statement DISABLE TRIGGER trg_InsertOrders ON Orders.


Display Answer

Answer: B, E

Explanation: You do not want to alter or delete the trigger, so that you can use the trigger again with the least administrative effort. You should use the DISABLE TRIGGER Transact-SQL command. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name [ ,...n ] | ALL } ON { object_name | DATABASE | ALL SERVER } [ ; ]