You are a database developer for Southridge Video. The company stores its sales information in a SQL
Server 2000 database. You are asked to delete order records from this database that are more than five
years old. To delete the records, you execute the following statement in SQL query analyzer:
DELETE FROM Orders WHERE OrderDate < (DATEADD (year, -5, getdate()))
You close SQL Query Analyzer after you receive the following message:



You examine the table and find that the old records are still in the table. The current connection
properties are shown in the exhibit.



A. Delete records in tables that reference the Orders table.
B. Disable triggers on the Orders table.
C. Execute a SET IMPLICIT_TRANSACTIONS OFF statement.
D. Execute a SET CURSOR_CLOSE_ON_COMMIT ON statement.
E. Change the logic in the DELETE statement.


Ответил С. Уже сомневаюсь - может они мели ввиду триггер, который откатывает все?