Interested to Buy Any Domain ? << Click Here >> for more details...
What is a NULL value? What are the pros and cons of using
NULLS?
- 2 Answers
- 9512 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 sqlca?
What is the function of buffer manager?
What are the three types of page locks that can be held?
What are the full forms of spufi and dclgen and why are they used?
What's the maximum number of characters that a tablename can have?
What is the STOSPACE Utility used for?
List out the data types available.
How to get the ddl of a table in db2?
How do you define a correlated name?
what is diffrence b/w file-aid tool and file-aid utility???
What is the use of predicate?
What is catalog database in db2?
COBOL 
