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


Please Help Members By Posting Answers For Below Questions

How to define a cusotmer as a supplier in ORACLE R12

1721


When do you get a .pll extension in oracle?

670


In the oracle version 9.3.0.5.0, what does each number shows?

737


What are the built-in functions used for sending Parameters to forms ?

2835


ABOUT IDENTITY?

1553






How to rename an index?

577


How to display employee records who gets more salary than the average salary in the department?

584


what is the difference between restoring and recovering?

546


What is a package in oracle?

560


What are the original export and import utilities?

565


What is the max number of columns in an oracle table?

506


What is a subquery?

606


How to create a table interactively?

547


Oracle

1837


How to create a new oracle data file?

548