Answer / s

Buffer manager is responsible for reading the data page
from DASD to Virtual storage.

List down the types of triggers in the db2 database?

0 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---

What is a DB2 catalog?

2 Answers  

---

Which catalog table stores referential constraints?

1 Answers  

---

What is db2 command?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

What are data types?

2 Answers  

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

---

What is the purpose of rollback and commit?

0 Answers  

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What is sqlcode -922 ?

2 Answers  

---