Mention the different locking levels that are available in db2.

1095

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1070

---

Discuss about db2 bind?

1061

---

List out the data types available.

1104

---

Define sqlca.

1067

---

Explain packages.

1068

---

Mention the definition of cobol in varchar field.

1203

---

Explain the function done by data manager?

1234

---

Define buffer pool.

1005

---

Outputs of explain are with matchcols = 0. What does this signify?

1008

---

Explain in detail about buffer manager and its functionalities?

1022

---

Mention the various locks that are available in db2.

985

---

Explain about dbrm.

1002

---

What does a deadlock mean in DB2?

1120

---

What is the advantage in De-normalizing tables in DB2?

1136

---