Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between CS and RR isolation levels?
- 1 Answers
- 8557 Views
- I also Faced
- E-Mail Answers
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
My sql statement select avg(salary) from emp yields inaccurate results. Why?
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 meant by explain?
What action db2 takes when a program aborts in the middle of a transaction?
What is a collection in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is dclgen in db2?
Before you give the explain statement, what are the prerogatives?
How do I add a column in db2?
What are types of indexes?
What is a plan and package in db2?
What are the different types of base tables?
Define sqlca.
can all users have the privilage to use the sql statement select * (dml)?
Why cursor is used in db2?
