nerdexam
IBM

A2090-560 · Question #133

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

(25 responses)
  • A
    4% (1)
  • B
    12% (3)
  • C
    8% (2)
  • D
    76% (19)

Community Discussion

No community discussion yet for this question.

Full A2090-560 Practice