On which levels locks can be applied?

0 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

What is database alias db2?

0 Answers  

---

Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

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,

---

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

How to check last update on table in db2?

0 Answers  

---

What is cursor stability?

1 Answers  

---

What is scrollable cursor in db2?

0 Answers  

---

what is parm utility

2 Answers   IBM,

---