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.

Answer 2

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

1. A blank space or zero is a valid value stored in a field, whereas NULL represents absence of any value (unknown or not available).
2. Arithmetic and comparison operations can be performed on zero or blank space, but NULL cannot be used in normal calculations or comparisons and requires special operators like IS NULL.