what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
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
What does fetching a cursor do?
How to run sql commands in sql*plus?
What is the difference between joins?
Does inner join remove duplicates?
Is sql a backend?
What does closing a cursor do?
i have some prob lem to tell me about my self in interview first round ...
how to check myisam tables for errors? : Sql dba
What are user defined functions?
what is single byte over head in oracle..?
What is ttitle and btitle?
what is an index? : Sql dba
What are views in sql?
How do you remove duplicates without using distinct in sql?
What are the benefits of pl/sql packages?