Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

When would you prefer to use VARCHAR?

Question Posted / guest

Answers were Sorted based on User's Feedback



When would you prefer to use VARCHAR?..

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.

Is This Answer Correct ?    6 Yes 0 No

When would you prefer to use VARCHAR?..

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.

Is This Answer Correct ?    6 Yes 2 No

When would you prefer to use VARCHAR?..

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 This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,

How to connect to db2 database from windows command line?

0 Answers  

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

What is performance tuning db2?

0 Answers  

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,

How do I add a column to an existing table in db2?

0 Answers  

What is the difference between db2 and oracle?

0 Answers  

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

What is a data page?

1 Answers  

what is difference between Plan and Package

1 Answers   Syntel,

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

For more DB2 Interview Questions Click Here
Categories