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
- 18723 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / guest
ACQUIRE, RELEASE determines when a partition, table or
tablespace lock will be acquired and released. ISOLATION
determines when a row, page lock will be acquired and
released. PAGE, ROW locks are released depending on the
ISOLATION level but almost always at commit or rollback.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is copy pending status in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Is db2 a programming language?
What are the prerogatives?
Why db2 is called db2?
What is db2 bind?
What is meant by union and union all?
Where do you specify them?
What is db2 command?
What is a collection in db2?
What is the role of schema in the db2 database?
What is the difference between bind and rebind in db2?
What are db2 tables?
What is dbrm library?
What is the clustering index in the db2 database?
