What is meant by repeatable read?
- 4 Answers
- 10769 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The qualifying rows under Repeatable read will ensure that
no rows will be changed or added for the duration of the
lock.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sf
In RR isolation level, all the pages fetched in the cursor
are locked till end of transaction. This is the safest way
to ensure that no concurrent update happened when the
cursor was actiong on this data.
The confusion would be on CS . In CS only the page having
the relevant data would be locked. As the page size is 4k ,
we may lock more than one row of a table based on row size
and table space organization.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
It is the highest level of isolation parameter. I will hold
the entire table till the completion of the transaction or
job. Others can not access that thable
| Is This Answer Correct ? | 1 Yes | 2 No |
Is it possible using max on a char column?
Is db2 a mainframe database?
How does cobol compile db2 program?
Explain the EXPLAIN statement?
When will you chose to run RUNSTATS?
What is coalesce in db2?
How many Buffer pools are there in DB2 and what are they?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is table space in db2?
what happend with out using Commit,when closing cursor and program?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Can you tell me how can you find out the # of rows updated after an update statement?
COBOL 
