Question

Give any two reasons to show that a blank space or zero is not the same as NULL value in SQL.

Answer 1

	NULL value	Zero and blank space
1.	A NULL value is a value, which is unavailable, unassigned, unknown or not applicable. It is used in the absence of any value. Arithmetic operations can be performed on it.	Zero is a number, and a blank space is treated as a character.
2.	The NULL value can be treated as an unknown and missing value.	A zero is a number and blank spaces are treated as characters
3.	One NULL may not be the same as another NULL. NULL indicates that no data has been provided or that no data exists.	A blank space or a zero can be compared to another blank space or a zero.