Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 3211 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 |
what is null value?
How to create a table in a specific tablespace?
select * from emp what happened internally when we write this query in the sql prompt?
What is integrity and what is constraint??Explain with example
Differentiate between function and procedure in oracle.
Name the various constraints used in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Explain about integrity constraint?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to create additional tablespaces for an new database?
In the oracle version 9.3.0.5.0, what does each number shows?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
Oracle General 
