nerdexam
IBM

C2090-558 · Question #86

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

The correct answer is C. You provide no value for a specific column. E. Where you specify the NULL keyword in the VALUES clause for a specific column. See the full explanation below for the reasoning.

Question

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

Options

  • AColumns that are used in indexes.
  • BColumns that are used in constraints.
  • CYou provide no value for a specific column.
  • DWhere a zero is specified in the VALUES clause of a serial column.
  • EWhere you specify the NULL keyword in the VALUES clause for a specific column.

How the community answered

(59 responses)
  • A
    12% (7)
  • B
    7% (4)
  • C
    80% (47)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice