what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 9937 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ajay.lavanuru
The lock mode convey the message of lock status starting
from low level hierarchy to high level hierarchy.
exclusive lock ---high priority
if this lock is enabled then 1 cant do nothing on the table.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I remove duplicates in two columns?
Is sql port 1433 encrypted?
Which is better cte or subquery?
What is the purpose of a sql?
How do you update a sql procedure?
What are the qualities of 2nf?
What is a constraint? Tell me about its various levels.
How to rename a column in the output of sql query?
How many parts of a pl sql block are optional?
what is try_catch block in procedure
how to rename an existing table in mysql? : Sql dba
what is single byte over head in oracle..?
how to shutdown mysql server? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
Does a user_objects view have an entry for a trigger?
