Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by repeatable read?
- 4 Answers
- 10308 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 |
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
Highlight all the advantages that are attached to a package.
What does an outer join do?
List down the types of triggers in the db2 database?
What are the disadvantages of PAGE level lock?
What do you need to do before you do EXPLAIN ?
What's the maximum number of characters that a tablename can have?
Can we update view in db2?
Name some fields from SQLCA.
Normalization in DB2 – first normal form, second normal form
what is diffrence b/w file-aid tool and file-aid utility???
What is clone table?
COBOL 
