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,

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

What is subquery ?

6 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

---

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

Define declaration generator (dclgen).

0 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

How do I delete a table in db2?

0 Answers  

---

Explain about mirror activator disk mirroring?

0 Answers  

---

what is plan? is plan executable or package?

4 Answers  

---