Answer / pradeep

a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence

datarows will be arranged based on the index in leaf pages

What are catalog tables in db2?

0 Answers  

---

Give the name of some fields form sqlca.

0 Answers  

---

what is copy pending and check pending ?

1 Answers   Xansa,

---

What is database alias db2?

0 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---

---

what is differnece between DROP TABLE & DELETE TABLE .

4 Answers   Cap Gemini,

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

1 Answers  

---

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

0 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

What is the logical entity between plan and Package?

5 Answers  

---

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

---