Answer Posted / sonu

Nice answer!!!!!!!!!!

What is an instance in db2?

1033

---

What are the different types of base tables?

1092

---

What is drop table?

1009

---

What is the use of dclgen in db2?

1085

---

What is consistency token in db2?

1141

---

Which component is responsible for processing sql statements and selecting access paths?

1127

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11673

---

What is the physical storage length of the data types date, time, and timestamp?

1086

---

List out the data types available.

1153

---

What is the clustering index in the db2 database?

1001

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1101

---

Define declaration generator (dclgen).

1114

---

Is db2 free?

1094

---

What is runstats and reorg in db2?

1302

---

List some fields from sqlca?

1056

---