Curioustab

Home » Database » SQL Server 2000

Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?

REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED

Correct Answer: REPEATABLE READ

Next Question→

More Questions from SQL Server 2000

In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Which of the following is a way to create and modify tables using SQL Server?
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
With which type of SQL Server recovery model are all database changes logged?
The strictest transaction isolation level provided by SQL Server is called:
Which of the three possible types of triggers does SQL Server support?
With which type of SQL Server recovery model, is no logging done?
SQL Server automatically creates an index on:
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion