what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 9944 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
Can we use views in stored procedure?
Can we use commit inside a trigger?
how can we destroy the cookie? : Sql dba
Mention what does the hierarchical profiler does?
what are integrity rules?
What happens when a trigger is associated to a view?
Is sql a microsoft product?
what is row? : Sql dba
Sql technical questions
What is sql partition?
What is an invalid partition table?
What is number function in sql?
Can we join more than 2 tables in sql?
What is attribute indicator in pl sql?
How do I create a sql script?
