Interested to Buy Any Domain ? << Click Here >> for more details...
In BIND, isolation level parameter specifies the duration
of page lock and ACQUIRE, RELEASE also do almost the same
thing. What is the exact difference between the two? Do
they work in conjunction while executing SQL queries and
obtaining locks?
- 8 Answers
- 19262 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / gopi
(1) Isolation specifies type of lock that should be used
(2) Acquire tells when the lock should be acquired
(3) Release tells when it should be unlocked
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what is the role of the cursor in db2?
What is the difference between spufi and qmf?
How can you do the explain of a dynamic sql statement?
How and when does the db2 enforces the unique key?
What are catalog tables in db2?
What is dbrm?
What are the different types of base tables?
What is universal database?
List out the buffer pools in db2
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is a db2 package?
What is role in db2?
Before you give the explain statement, what are the prerogatives?
What is load replace in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
