Describe the different type of Integrity Constraints
supported by ORACLE ?
Answer Posted / allin
5 Different integrity constraints are given
1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.
Thanks & Regards,
RatnaRao
9833847339
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to define a cusotmer as a supplier in ORACLE R12
When do you get a .pll extension in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
What are the built-in functions used for sending Parameters to forms ?
ABOUT IDENTITY?
How to rename an index?
How to display employee records who gets more salary than the average salary in the department?
what is the difference between restoring and recovering?
What is a package in oracle?
What are the original export and import utilities?
What is the max number of columns in an oracle table?
What is a subquery?
How to create a table interactively?
Oracle
How to create a new oracle data file?