What is the difference between CS and RR isolation levels?
Answer Posted / s
CS - page or row locks are released as soon as the cursor
is moved to another row or page.
RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to find schema of a table 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 ?
Why select is not preferred in embedded sql programs?
What is the physical storage length of the data types date, time, and timestamp?
How many databases are there?
What is database manager in db2?
What is the connection string to connect to the DB2 Database ?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the picture clause of null indicator variable?
What is difference between rollback and commit?
What is the usage of open cursor command?
What is precompiler in db2?
Why do we bind in db2?
Is the primary key a clustered index?
What is the function of logging in the db2 database?