what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
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 union and union all keyword in sql?
What is a database event trigger?
what are date and time functions in mysql? : Sql dba
What does stand for in sql?
What are sql queries used for?
What is the purpose of the sql select top clause?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is primary key secondary key alternate key candidate key?
What is natural join in sql?
What is right join in sql?
What is consistency?
How to assign sql query results to pl sql variables?
How do you optimize a stored procedure query?
What is triggering circuit?
Mention what does the hierarchical profiler does?