what are the differences among these table level lock
modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE
MODE ?
- 3 Answers
- 9915 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
Why is a trigger used?
What can I use instead of union in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How run sql*plus commands that are stored in a local file?
What does joining a thread mean?
Why schema is used in sql?
How can get second highest salary in sql?
What is snowflake sql?
What is rank () in sql?
What are the triggers associated with image items?
What is procedure in pl sql?
What is function and procedure?
What do you think about pl/sql?
Explain the difference between 'between' & 'and' operators in sql
How can we optimize a sql query?
