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

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

2 Answers   Logica CMG,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

---

What is a data page?

1 Answers  

---

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

0 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

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 a NULL value? What are the pros and cons of using NULLS?

2 Answers  

---