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
- 18867 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 a Foreign Key?
What is bind plan?
Explain in detail about buffer manager and its functionalities?
Which are the db2 tools to protect integrity of the database?
How do you eliminate duplicate values in db2?
What is runstats db2?
How to find the number of rows in db2 tables?
what is diffrence b/w file-aid tool and file-aid utility???
What are iseries servers?
What is db2 optimizer?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Why do we use cursor?
What do you mean by rollback?
How do I import data from excel to db2?
What is cloudant database?
