nerdexam
Oracle

1Z0-061 · Question #166

Which two statements are true about constraints? (Choose two.)

The correct answer is B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. D. The NOT NULL constraint ensures that null values are not permitted for the column. See the full explanation below for the reasoning.

Question

Which two statements are true about constraints? (Choose two.)

Options

  • AThe UNIQUE constraint does not permit a null value for the column.
  • BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
  • CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
  • DThe NOT NULL constraint ensures that null values are not permitted for the column.

How the community answered

(27 responses)
  • A
    15% (4)
  • B
    81% (22)
  • C
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice