SQL Server 2000 READ COMMITTED is the default isolation level. True False True False 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 BEGIN trigger BEFORE trigger INSTEAD OF trigger AFTER trigger BEGIN trigger BEFORE trigger INSTEAD OF trigger ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Better security occurs if Windows-only authentication is selected. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With which type of SQL Server recovery model, is no logging done? Simple recovery Bulk-logged recovery Differential recovery Full recovery Simple recovery Bulk-logged recovery Differential recovery Full recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data. Clustered Secondary Primary Nonclustered Clustered Secondary Primary Nonclustered ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With SQL Server pessimistic locking, no lock is obtained until the user updates the data. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS