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 many sub queries can you combine together ?

4 Answers   IBM,

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What is null value in db2?

0 Answers  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

Which isolation level provides maximum concurrency?

0 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

what is load and unload in db2

1 Answers   IBM,

---

What is a DB2 bind?

1 Answers   Logica CMG,

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---