IBM
P2090-050 · Question #32
When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statement, which of these…
The correct answer is D. 0 is not equal to null, the empty string ( '' ) is not equal to null. See the full explanation below for the reasoning.
Question
When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statement, which of these is true?
Options
- A0 is equal to null, the empty string ( '' ) is equal to null.
- B0 is equal to null, the empty string ( '' ) is not equal to null.
- C0 is not equal to null, the empty string ( '' ) is equal to null.
- D0 is not equal to null, the empty string ( '' ) is not equal to null.
How the community answered
(43 responses)- A14% (6)
- B5% (2)
- C7% (3)
- D74% (32)
Community Discussion
No community discussion yet for this question.