Interested to Buy Any Domain ? << Click Here >> for more details...
4. A DB2 application is bound with uncommitted Read
isolation level.It issues a request that retrieves 20 rows
out of 200000 in the table.
Which of the following descrbes the rows that are locked
as a result of this request?
a. None of the rows are locked.
B.The retrieved rows are locked.
C.The last row of the result set is locked.
D.The rows not previously updated by another application
are locked.
- 3 Answers
- 9329 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / hussain
b. the retrieved rows are locked
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
List down the types of triggers in the db2 database?
When do you specify the isolation level?
What does runstats do in db2?
What are packages in db2?
Why do chiropractors use drop table?
What does reorg do in db2?
What are iseries servers?
Are view updateable?
Why do we use cursor?
How to find primary key of a table in db2?
What are the contents of dclgen?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the use of dclgen in db2?
What is the meaning concurrency in the db2 database?
