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
- 18881 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / p praveen kumar
1) Isolation specifies types of locks to be used by
Repeatable Reads(Table space locks), Reads
Stability(page level locks), Cursor Stability(Row level Locks)
Uncommitted locks(no Locks)
2) Acquire tells when the lock should be acquired(USE,ALLOCATE)
3) Release tells when it should be unlocked(COMMIT, DEAL LOCATE)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What os does db2 run on?
How connect db2 database to datastage?
What is cursor with hold option in db2?
How to rename a table in DB2 ?
What is rct?
How to run db2 command in windows?
What is a db2 tablespace?
What does db2 blu stand for?
What is cursor stability in db2?
What are the 2 sqlcodes that are returned?
What does sqlcabc has?
What is load replace in db2?
How do you select a row using indexes in db2?
How do I start db2 in windows?
What are foreign keys in db2?
