Describe the different type of Integrity Constraints supported by ORACLE?
Submitted by: AdministratorNOT 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Database Architecture Job Interview Questions And Answers
Top Database Architecture Questions
| ☺ | Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint? |
| ☺ | How to define Data Block size in Oracle? |
| ☺ | What is an Oracle Data Segment? |
| ☺ | What is an oracle database schema? |
| ☺ | What is an Integrity Constrains in Oracle? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
