Answer Posted / s

750

what is db2 restart?

2158

---

What is the difference between cursor stability and repeatable read isolation levels?

1173

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1080

---

What is nvl in db2?

1093

---

What is the maximum number of columns in a db2 table?

1283

---

What is bufferpool in db2?

1052

---

Mention data types used in db2 ?

1156

---

Give the name of some fields form sqlca.

1077

---

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

1057

---

What is the use of db2 optimizer?

1114

---

How can deadlocks be resolved?

935

---

How do I add a column in db2?

1048

---

What is bind in db2?

1042

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9197

---

What is db2 connect?

1067

---