what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
Answer Posted / ajay.lavanuru
The lock mode convey the message of lock status starting
from low level hierarchy to high level hierarchy.
exclusive lock ---high priority
if this lock is enabled then 1 cant do nothing on the table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can we alter stored procedure?
what are the security recommendations while using mysql? : Sql dba
What does <> sql mean?
Can we use joins in subquery?
Sql technical questions
What is the difference between database trigger and stored procedure?
Is sql a scripting language?
Why stored procedure is faster than query?
how to check server status with 'mysqladmin'? : Sql dba
how would you enter characters as hex numbers? : Sql dba
What is the primary use of normalization?
what is the difference between sql and t-sql? : Transact sql
What are the advantages of stored procedure?
What are the built in functions of sql?
What is sqlca in db2?