SQL Server 2000 SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): BEFORE trigger BEGIN trigger INSTEAD OF trigger AFTER trigger BEFORE trigger BEGIN trigger INSTEAD OF trigger AFTER trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server automatically creates an index on: both primary and foreign keys primary keys only foreign key only SQL Server never automatically creates an index both primary and foreign keys primary keys only foreign key only SQL Server never automatically creates an index ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports INSTEAD OF, AFTER and BEFORE triggers. True False True False 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 READ COMMITTED is the default isolation level. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS