With SQL Server pessimistic locking, no lock is obtained until the use – McqOptions

MCQOPTIONS

1.	With SQL Server pessimistic locking, no lock is obtained until the user updates the data.%!
A.	True
B.	False
Answer» C.

Discussion

No Comment Found

Related MCQs

Which of the following is a factor in determining the concurrency control behavior of SQL Server?
Nonclustered indexes are faster than clustered indexes for retrieval.%!
By default, SQL Server will create one data file and one log file for each newly created database.%!
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.%!
With SQL Server, parameters and variables in T-SQL start with the "%" sign.%!
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.%!
SERIALIZABLE is the strictest isolation level.%!
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.%!
'dbo' stands for database object.%!
SQL Server supports three recovery modes: simple, full and Bulk.%!