Which of the three possible types of triggers does SQL Server support?
A. INSTEAD OF only
B. AFTER only
C. BEFORE only
D. INSTEAD OF and AFTER only
Answer: Option D
Related Questions on SQL Server 2000
A. Differential recovery
B. Full recovery
C. Simple recovery
D. Bulk-logged recovery
What mode of authentication does SQL Server NOT provide?
A. Windows-only security
B. Both SQL Server and Windows-only security
C. Mixed security
D. SQL Server only security
The strictest transaction isolation level provided by SQL Server is called:
A. REPEATABLE READ
B. SERIALIZABLE
C. READ COMMITTED
D. READ UNCOMMITTED
Join The Discussion