Interested to Buy Any Domain ? << Click Here >> for more details...
what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 11273 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 varchar data type in sql?
What is pls integer?
What is the meaning of disabling a trigger?
Is sql procedural language?
Can you upgrade sql express to full sql?
How do you get column names only for a table (sql server)?
Why do we need pl sql?
How many row comparison operators are used while working with a subquery?
What is sql entity?
What has stored procedures in sql and how we can use it?
How does sql developer connect to oracle database?
What is procedure function?
What is difference between joins and union?
How do you write an inner join query?
What is thread join () in threading?
