SQL Server 2000 Which of the three possible types of triggers does SQL Server support? INSTEAD OF only AFTER only INSTEAD OF and AFTER only BEFORE only INSTEAD OF only AFTER only INSTEAD OF and AFTER only BEFORE only ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which of the following is not a factor in determining the concurrency control behavior of SQL Server? Lock level Locking hints Transaction isolation level Cursor concurrency setting Lock level Locking hints Transaction isolation level Cursor concurrency setting ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SERIALIZABLE is the strictest isolation level. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 A differential backup makes a copy of the entire database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The strictest transaction isolation level provided by SQL Server is called: READ COMMITTED REPEATABLE READ READ UNCOMMITTED SERIALIZABLE READ COMMITTED REPEATABLE READ READ UNCOMMITTED SERIALIZABLE ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server program code that is executed after an SQL command has been processed is called a(n): AFTER trigger BEFORE trigger BEGIN trigger INSTEAD OF trigger AFTER trigger BEFORE trigger BEGIN trigger INSTEAD OF trigger ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS