Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 161

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

    Correct Answer: B, E

    A constraint can be disabled even if the constrained column contains data, which means the database does not enforce the constraint when it is disabled. A column with a UNIQUE constraint can contain a NULL value because NULLs are not considered equal to anything, including other NULLs, so multiple NULL values do not violate the UNIQUE constraint. A column with a FOREIGN KEY constraint can contain a NULL value, as it simply implies that the value must either be NULL or match a value in the referenced column.

Discussion
yaya32Option: B

BE is correct

kesammy9Option: B

BE is the correct answer.

ArslanAltafOptions: BE

BE is correct

Arth1989Options: BE

BE 100%. Why so many answers are incorrectly marked?

WingLOption: B

B AND E CORRECT

Rik92Option: B

BE is correct

OrakolOptions: BE

BE is correct. A is false, a Foreign Key column can contain Null values.

jfc1Option: E

AE is good