What are the various isolation levels possible?

0 Answers  

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---

what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

What happens in bind step in a db2 program?

0 Answers  

---

Mention the different locking levels that are available in db2.

0 Answers  

---

Explain db2.

0 Answers  

---

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 can an insert of a new primary key value threaten referential integrity?

2 Answers   Mind Tree,

---

What is dbrm? What it contains?

0 Answers  

---

What is the purpose of using commit?

0 Answers  

---