Answer Posted / vaneesh khurana

Awesome explanation in Easy language...

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1032

---

How to compare data between two tables in db2?

1027

---

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

1210

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2778

---

What is the information associated with sysibm.syslinks table?

1055

---

Why cursor is used in db2?

983

---

What is db2 instance?

1015

---

What is a system catalog table in db2?

1097

---

What does db2 mean?

954

---

What is runstats db2?

962

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1180

---

Explain the contents that are a part of dclgen.

1031

---

What is alias in db2?

980

---

How can deadlocks be resolved?

888

---

How do I delete a table in database?

974

---