nerdexam
IBM

C2090-600 · Question #27

Which statement about NOT ENFORCED unique constraints is TRUE?

The correct answer is A. NOT ENFORCED unique constraints can not be defined on primary key columns. See the full explanation below for the reasoning.

Question

Which statement about NOT ENFORCED unique constraints is TRUE?

Options

  • ANOT ENFORCED unique constraints can not be defined on primary key columns
  • BThe query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal
  • CWhen attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a
  • DStorage requirements for a NOT ENFORCED unique constraint are no different than the storage

How the community answered

(32 responses)
  • A
    78% (25)
  • B
    3% (1)
  • C
    13% (4)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full C2090-600 Practice