Explanation:When SERIALIZABLE isolation level is set – a range lock is placed on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. 5. Point out the wrong statement :
A. Schema modification (Sch-M) locks are used when a table data definition language operationis being performed
B. By default, SQL Server transactions times out after a certain time
C. Disallowing a locking level can affect concurrency adversely.
D. Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required.
Answer:A
Explanation:When SERIALIZABLE isolation level is set – a range lock is placed on the data set, preventing other users from updating or inserting rows into the data set until the transaction is complete. 5. Point out the wrong statement :
A. Schema modification (Sch-M) locks are used when a table data definition language operationis being performed B. By default, SQL Server transactions times out after a certain time C. Disallowing a locking level can affect concurrency adversely. D. Table-level locking hints can be used when a finer control of the types of locks acquired on an object is required.
Explanation:SQL Server transactions do not time out (unless LOCK_TIMEOUT is set) 6. __________ locks allow processes to bulk copy data concurrently into the same table.