SQL Server 2000 READ COMMITTED is the default isolation level. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server 2000 stored procedures can: never be kept within the database be stored on the users' computer be kept within the database and invoked by application programs support BEFORE, INSTEAD OF and AFTER types never be kept within the database be stored on the users' computer be kept within the database and invoked by application programs support BEFORE, INSTEAD OF and AFTER types ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): AFTER trigger INSTEAD OF trigger BEFORE trigger BEGIN trigger AFTER trigger INSTEAD OF trigger BEFORE trigger BEGIN trigger 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: SERIALIZABLE READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE READ COMMITTED READ UNCOMMITTED REPEATABLE READ ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? OPTIMISTIC SCROLL_LOCK READCOMMITTED READ_ONLY OPTIMISTIC SCROLL_LOCK READCOMMITTED READ_ONLY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS