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   Wipro,

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

What is dpf in db2?

0 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

When will you chose to run RUNSTATS?

1 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---

What is DB2 (IBM Database 2)?

3 Answers  

---

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

What is meant by AUTO COMMIT?

3 Answers  

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---