| |||||
 |
|
|
|||
|
|
What is Exclusive Locks? More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) What is Exclusive Locks? When a statement modifies data, its transaction holds an exclusive lock on data that prevents other transactions from accessing the data. This lock remains in place until the transaction holding the lock issues a commit or rollback. Table-level locking lowers concurrency in a multi-user system. (Continued on next question...)
Other Job Interview Questions
|
||||
|
|
|
|||
