Explain in detail about buffer manager and its functionalities?

0 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,

---

How does DB2 use multiple table indexes?

1 Answers  

---

How is the value function used?

0 Answers  

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

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

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

What is explain plan in db2?

0 Answers  

---

How do I delete a column in db2?

0 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

---