Computer Science
Assertion. There is a difference between a field being empty or storing NULL value in a field.
Reason. The NULL value is a legal way of signifying that no value exists in the field.
SQL Queries
4 Likes
Answer
(a)
Both Assertion and Reason are true and Reason is the correct explanation of Assertion.
Explanation
There is a difference between a field being empty or storing NULL value in a field. An empty field means that the field contains a value, but that value is an empty string or a space, depending on the data type. In contrast, if a column in a row has no value, then column is said to contain a NULL. Hence, the NULL value is a legal way of signifying that no value exists in the field.
Answered By
2 Likes
Related Questions
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Assertion. The ALL and DISTINCT clauses of a SELECT query are related.
Reason. The ALL clause is the opposite of the DISTINCT clause of a SELECT Query.
Assertion. The WHERE and HAVING clauses are used for the same thing in a SELECT query.
Reason. Both WHERE and HAVING clauses are used to specify conditions at different levels.