Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of PAGE level lock?
- 3 Answers
- 8176 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 |
How many types of page locks can be held in db2?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What are the various locking levels available?
Explain the benefits you can get from mainframe connect?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
What is sqlca?
what is Runstats? Whem will u choose to runatats?
What is the significance of DB2 free space and what parameters control it?
What is dbrm? When it will be created?
What are the functions in DB2?
What is the function of buffer manager?
COBOL 
