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

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

what are the max. & min. no. of partitions allowed in a partition tablespace?

1 Answers   IBM,


What will the FREE command do to a plan?

2 Answers  


What is reorg in database?

1 Answers  


What is the meaning of -805 SQL return code?

3 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,






How does db2 sample database connect?

0 Answers  


What are the full forms of spufi and dclgen and why are they used?

0 Answers  


What is Reorg Recovery? when will you run it?

2 Answers  


What is the picture clause of null indicator variable?

0 Answers  


Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


When DB2 connection fails, will online program work or give errors.

1 Answers   Virtusa,


what is utility for parm lib

0 Answers   IBM,


Categories