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
10 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
3 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.