1z0-071 Oracle Database 12c SQL 第6题 constraints约束

Q6. Which two statements are true regarding constraints? (Choose two)

A.A foreign key cannot contain NULL values.

B.A column with the UNIQUE constraint can contain NULL.

C.A constraint is enforced only for the INSERT operaton on a table.

D.A constraint can be disabled even if the constraint column contains data. 即使约束列包含数据，约束也可以被禁用。

E.All the constraints can be defned at the column level as well as the table level

Correct Answer: BD

对于 A 选项，foreign key 可以包含 null

对于 C 选项，constaint 在 delete，update 的时候也会应用。

对于 E 选项，not null 不能在表级别定义，只能在列级别定义。