What is meant by repeatable read?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sqlca.

647


How do you select a row using indexes in db2?

643


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3116


What are host variables in db2?

624


How do you simulate the explain of an embedded sql statement in spufi/qmf?

634






Name the various locking levels available?

632


Which component is responsible for db2 startup and shutdown?

624


What is temporal table in db2?

601


What is dbrm in db2 database?

584


How can you count the number of rows from a table tab?

633


Explain the contention situations caused by locks?

589


How do I add a column in db2?

589


What is rct?

751


How to fetch the last row from the table in SQL (db2)?

1035


What is buffer pool?

607