Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 2977 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 |
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
How to call a stored function in oracle?
What is OCI. What are its uses?
How to convert times to characters in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to open a cursor variable?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is integrity and what is constraint??Explain with example
Explain how you would restore a database using RMAN to Point in Time?
How to pass parameters to procedures?
What is query image?
Oracle General 
