SQL Server 2000 With SQL Server pessimistic locking, no lock is obtained until the user updates the data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server indexes are special data structures used to improve performance. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports a language called Transact-SQL (also called T-SQL). True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The strictest transaction isolation level provided by SQL Server is called: READ UNCOMMITTED REPEATABLE READ READ COMMITTED SERIALIZABLE READ UNCOMMITTED REPEATABLE READ READ COMMITTED SERIALIZABLE ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With SQL Server optimistic locking, an update lock is placed on the row when the row is read. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. False True False True ANSWER DOWNLOAD EXAMIANS APP