Question

Null value is the special value which represents :

• A. Stores value items
• B. Data with many values
• C. Absence of data items
• D. Single value data item

Hint:

NULL is a fundamental concept in databases. Remember NULL is not the same as 0 (zero) or an empty string (''). It means 'no value', 'missing', or 'unknown'.

Answer 1

The Correct Option is C

To solve the problem, we need to understand what a null value signifies in the context of data and databases.

1. Understanding Null Value:
A null value is used to represent the absence of a value or when the value is unknown or not applicable. It is not the same as a zero, blank, or empty string — it simply means “no data.”

2. Correct Option Analysis:

• (A) Stores value items — Incorrect, because a null value stores no value.
• (B) Data with many values — Incorrect, null means no value, not multiple values.
• (C) Absence of data items — Correct, this matches the definition of null.
• (D) Single value data item — Incorrect, null does not refer to a value, but the lack of one.

Final Answer:
Correct Option: (C) Absence of data items