what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 9912 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
Why do we use function in pl sql?
List the various privileges that a user can grant to another user?
What is difference between rank () row_number () and dense_rank () in sql?
Can we join 3 tables in sql?
What is the difference between function, procedure and package in pl/sql?
How would you reference column values before and after you have inserted and deleted triggers?
What is sql injection owasp?
what are different types of keys in sql?
what is an index? : Sql dba
How to add new employee details in an employee_details table with the following details
What is sql lookup?
What is the difference between truncate and drop statements?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Why is nosql good?
How do I make sql search faster?
