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
How to create your own reports in sql developer?
What is the command used to fetch first 5 characters of the string?
What are its different types of dbms?
Can a composite key be null?
What are the constraints available in sql?
what is myisam? : Sql dba
Show how functions and procedures are called in a pl/sql block.
What are the set operators in sql?
What are the basic sql commands?
What is keys and its types?
Define tables and fields in a database
How will you distinguish a global variable with a local variable in pl/sql?
What do you mean by stored procedures?
what is sql? : Sql dba
What is the life of an sql statement?