Answer / s

The obvious benefit is savings in disk space. Thus reduced
row length means more rows per page which means lesser
getpages. Fewer getpages mean less locks hence less CPU
costs and less I/O. Use of VARCHAR reduces the number of
bytes passed between DB2 and application. There is a CPU
cost associated with each byte of data moved.

Answer / sunil1405

when u declare a column with 10 bytes and only the field is
using 6bytes of storage , the balance 4 bytes will be
reclaimed ie its not wasted.

Answer / kums

Rather than storing the object in the data base, specify
the location of the object (image) by creating a column
with VARCHAR. This kind of approach may be used in web
technologies. pl correct if I'm wrong.

Is Cursor exicutable ?

3 Answers   TetraSoft,

---

What can the Locate option of the Repair Utility accomplish?

2 Answers  

---

What is bind in db2?

0 Answers  

---

What is check constraint. Explain with example.

0 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?

2 Answers  

---

What is EXPLAIN?

1 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What is the difference between CS and RR isolation levels?

1 Answers  

---

What is a cursor?

2 Answers  

---

what is a collection?

2 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---