what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 11561 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 bcp? When does it used? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Does group by remove duplicates?
what is sql server agent? : Sql dba
How do I remove duplicates in two columns?
What is the current version of sql?
Is inner join faster than left join?
what is collation? : Sql dba
Can we use distinct and group by together?
Do we need to rebuild index after truncate?
how many tables will create when we create table, what are they? : Sql dba
what are the advantages of sql ? : Sql dba
how to start mysql server? : Sql dba
Can delete statement be rollbacked?
what are aggregate and scalar functions? : Sql dba
