what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 10528 Views
- HCL, I also Faced
- E-Mail Answers
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
Write a unique difference between a function and a stored procedure.
What is sharding in sql?
Why truncate is faster than delete?
What is server name sql?
Is drop table faster than truncate?
What is the usage of when clause in trigger?
Is microsoft sql free?
How do I get sql certification?
What is the use of triggers?
what are the different index configurations a table can have? : Sql dba
what is oracle database ? : Sql dba
How to call shell script from pl sql procedure?
What is the use of procedures?
How do you explain an index number?
What is the difference between sql and mysql?
