Interested to Buy Any Domain ? << Click Here >> for more details...
What is meant by repeatable read?
- 4 Answers
- 10468 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 |
What is meant by dclgen?
Explain about open switch business continuity software?
What are bind parameters in db2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
What is nvl in db2?
What information is held in SYSIBM.SYSCOPY?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
Can we declare DB2 HOST variable in COBOL COPY book?
What is explain in db2?
Can SQL statements/queries be included in a copybook?
Is it possible using max on a char column?
What is the logical entity between plan and Package?
COBOL 
