what is the difference between where clause and having clause

2 Answers   IBM,

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

What is deadlock?

2 Answers  

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---

Define check constraint.

0 Answers  

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

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

1 Answers   IBM,

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

how we will do null data selection in cobol-db2 program

2 Answers   Wipro,

---

What does the REORG Utility do?

2 Answers  

---

What are the various locking levels available?

3 Answers  

---