Answer Posted / vaneesh khurana

Awesome explanation in Easy language...

Describe major components of db2?

652

---

What is the difference between spufi and qmf?

650

---

Can we insert update delete in view?

587

---

Is db2 free?

696

---

Why cursor is used in db2?

583

---

---

Mention some fields that are a part of sqlca.

610

---

What is null in db2?

581

---

What is lock escalation in db2?

586

---

Which component is responsible for db2 startup and shutdown?

640

---

Mention the location where the output received from explain statement is stored.

641

---

can we view the access paths created by dbrm ? how ? thx

6280

---

What is db2 plan table?

635

---

What are the 2 sqlcodes that are returned?

653

---

What is the difference between drop table and delete table?

567

---

List some fields from sqlca?

619

---