Answers

Question and Answer:

  Home  Oracle Architecture and Concepts

⟩ Explain the different type of Integrity Constraints supported by ORACLE?

NOT NULL Constraint - Disallows Nulls in a table's column.

UNIQUE Constraint - Disallows duplicate values in a column or set of columns.

PRIMARY KEY Constraint - Disallows duplicate values and Nulls in a column or set of columns.

FOREIGN KEY Constrain - Require each value in a column or set of columns match a value in a related table's UNIQUE or PRIMARY KEY.

CHECK Constraint - Disallows values that do not satisfy the logical expression of the constraint.

 117 views

More Questions for you: