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
- 19265 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / priya
When a tablespace is locked, another task cannot have
access to the entire table itself. So here, does page level
locking matter and what difference remains between
ISOLATION and ACQUIRE/RELEASE?
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you eliminate duplicate values in db2?
What is concurrency?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What do you mean by cursor?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is db2?
What is catalog database in db2?
i want to maintain uniqueness on pdf without make lf??????????
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is difference between alias and synonym in db2?
What is temporal table in db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is table space in db2?
Explain about open switch business continuity software?
What is a bind in db2?
