What are the disadvantages of PAGE level lock?
- 3 Answers
- 8598 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Less concurrency. Lock contention occurs when an
application program is trying to acquire a lock that is
already held by another program.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / thomas john
high resource utilization when large updates are to be done
| Is This Answer Correct ? | 2 Yes | 2 No |
If I have a view which is a join of two or more tables, can this view be updatable?
How can you compare table column after update and before update?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What techniques will be used to avoid deadlock??
What is nvl in db2?
What is subquery ?
What is the difference between using bind () and rebind () methods of naming class?
COBOL 
