Oracle Database Architecture Question:
Download Questions PDF

Describe the different type of Integrity Constraints supported by ORACLE?

Answer:

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.

Download Database Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
What is the function of Redo Log in Oracle?What is an Oracle Data Dictionary?