What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 480 Views
- I also Faced
- E-Mail Answers
A deadlock occurs when two or more transactions hold locks that the other needs, causing them to wait indefinitely.
Ways to prevent deadlocks:
• Use consistent lock ordering.
• Keep transactions short and fast.
• Use lower isolation levels when possible.
• Implement deadlock detection mechanisms.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to define a variable to match a table column data type?
How to drop a stored procedure in oracle?
What are the different types of trigger and explain its various uses and functions?
What is an Oracle Instance?
How to create a table index?
What is rich query?
What is difference between cartesian join and cross join?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
List out the types of joins.
What is difference between Rename and Alias?
How would you design a database for an e-commerce website?
What are the execution control statements?
Oracle General 
