C) all of the above.
D) none of the above.
A) stored within the database.
B) given a unique name.
C) called by name.
D) all of the above.
A. Delete the row from the Inserted table.
B. Delete the row from the Sales table.
C. Do nothing; the trigger will do it automatically.
D. Delete the row from both the Inserted and the Sales tables.
A. The data resides in the Inserted and the Category tables.
B. The data resides in only the Inserted table.
C. The data resides in only the Category table.
D. The data resides in the Inserted and Deleted tables.
A. They are not faster.
B. The query plan is compiled and cached on the server.
C. The Transact-SQL statements are shorter.
D. There are less commands available, so parsing time is shorter.