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. B: A unique constraint can contain null values because null values cannot be compared to D: The NOT NULL constraint ensure that null value are not permitted for the column Incorrect answer: A statement is not true C statement is not true

Creating and Managing Schema Objects

Question

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

(16 responses)

A
6% (1)
B
81% (13)
C
13% (2)

Explanation

B: A unique constraint can contain null values because null values cannot be compared to D: The NOT NULL constraint ensure that null value are not permitted for the column Incorrect answer: A statement is not true C statement is not true

Topics

#UNIQUE constraint#PRIMARY KEY#NOT NULL#indexes

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice