What is deadlock?
- 2 Answers
- 6157 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Deadlock is a situation where two programs are waiting on
each other's lock to be released.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srikanth
when two applications trying to access the same table that
the table is locked by another table is called deadlock
| Is This Answer Correct ? | 2 Yes | 1 No |
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What information can you find in SYSIBM.SYSLINKS table?
How are write I/Os from the buffer pool executed?
what is the soft code for deadlock ?
What are foreign keys in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is a synonym ?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is a DBRM, PLAN ?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is the purpose of using commit?
COBOL 
