what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 9945 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
How do I upgrade sql?
How do I add a database to sql?
How to prepare for oracle pl sql certification?
What is the maximum rows in csv?
What is the maximum number of columns in sql table?
Why do we use partitions in sql?
What is varchar example?
What is the use of count (*) in sql?
is it possible to pass an object or table to a procedure as an argument?
Can primary key be changed?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What do you understand by pl/sql cursors?
What is sql and also describe types of sql statements?
What is the need of merge statement?
Are stored procedures faster than dynamic sql?
