What is cursor with hold option in db2?

0 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

Explain what are the various isolation levels possible?

0 Answers  

---

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

3 Answers  

---

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,

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

What is concurrency in db2?

1 Answers  

---

What is a clustering index?

2 Answers  

---

What is drop table?

0 Answers  

---

how can u understand the end of the table ?

1 Answers   TCS,

---