what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 10527 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / raji_4u
in share mode :
this mode is for read only on entire table.
we can not make changes to table.
any user can have a lock in share mode at same time.
in share update mode :
this mode is used to lock the selected rows for update.
this mode acquires lock on selected rows only,not entire table.
other user can have lock on other rows on the same table but
not on the rows you have locked.
in exclusive mode :
this acquires lock on entire table.
another user can not have any lock on that table.
| Is This Answer Correct ? | 21 Yes | 1 No |
Post New Answer View All Answers
What is native sql query?
What is the use of procedures?
What is the usage of sql functions?
Explain some predefined exceptions.
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Is inner join same as self join?
What is a delimiter in sas?
What is the difference between sql and mysql?
How do I run a pl sql program?
What is a pdo connection?
What is difference between sql and oracle?
What is an inconsistent dependency?
What is the difference between microsoft sql and mysql?
What is the difference between having clause and where clause?
What is the difference between the implicit and explicit cursors?
