How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

Explain the contention situations caused by locks?

0 Answers  

---

When reorg is used?

0 Answers  

---

what are the bind parameters?

5 Answers   IBM,

---

What type of database is db2?

0 Answers  

---

What is db2 optimizer?

0 Answers  

---

What is meant by dclgen?

0 Answers  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

max number of columns in a db2 table?

6 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

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,

---

When do you specify the isolation level?

0 Answers  

---