What is meant by repeatable read?
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 |
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is db2 plan table?
What techniques are used to retrieve data from more than one table in a single SQL statement?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What is cloudant database?
What is db2?
What is the syntax for FETCH in DB2 ?
What is cobol db2?
What is innodb buffer pool?
What keyword does an SQL SELECT statement use for a string search?
can any one expalin check point with an example?
What are the four lockable units for DB2?