Answer Posted / raghunadhareddy

Excellent explanation Suresh

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

1041

---

How will you return the number of records in table?

915

---

What is the function of logging in the db2 database?

1102

---

What is check constraint in db2?

1062

---

What is db2 look?

1007

---

What is sqlca?

1053

---

If I have a view which is a join of two or more tables, can this view be updateable?

1126

---

What is difference between isnull and coalesce?

1040

---

Mention data types used in db2 ?

1141

---

On which levels locks can be applied?

1110

---

How do I change the column size in db2?

1130

---

Is ibm db2 open source?

1052

---

What is a plan and package in db2?

1086

---

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

1151

---

How to check sequence on a table in db2?

1044

---