What is a deadlock in SQL? How can you prevent it?
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 |
What is a subquery?
What are the four Oracle system processes that must always be up and running for the database to be useable?
what are different types of deletes?
What is a tns service name?
How to start your 10g xe server?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is the disadvantage of User defind function?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What are synonyms used for ?
What is parameterized cursor in oracle?
What are the attributes of the cursor?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me