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

What is a NULL value? What are the pros and cons of using
NULLS?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is a NULL value? What are the pros and cons of using NULLS?..

Answer / s

NULL Value indicates the absence of a value. DB2 treats
NULL as an actual value and is not equal to blank, zero or
empty string.

The default value of a CHAR data type is blanks, VARCHAR is
empty string and INT,SMALLINT,FLOAT etc is 0.
NULL is not equal to any of the above.

NULLs does not satify any condition in the SQL except when
IS NULL predicate is used. Null can be used at times when
you cannot specify a value for a column, eg middle names,
not everyone has middle names.

Is This Answer Correct ?    9 Yes 0 No

What is a NULL value? What are the pros and cons of using NULLS?..

Answer / sunil1405

A null value indicates that there is blank value in the
column field. It takes one byte of storage. Null value
requires special prog. to be handled in the app. prog

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More DB2 Interview Questions

Is db2 relational database?

0 Answers  

What is the meaning of -805 SQL return code?

3 Answers  

What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?

5 Answers   Emsang,

What is the use of dclgen in db2?

0 Answers  

What does runstats do in db2?

0 Answers  

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

What is REORG? When is it used?

4 Answers  

What does reorg do in db2?

0 Answers  

What does a deadlock mean in DB2?

0 Answers  

What is the database descriptor?

2 Answers  

How does DB2 use multiple table indexes?

1 Answers  

How can deadlocks be resolved?

0 Answers  

For more DB2 Interview Questions Click Here
Categories