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

What are the types of partitions in oracle?

774


What is oracle analytical function?

756


How to assign values to variables?

830


Can you drop an index associated with a unique or primary key constraint?

785


What is an external table?

786


What is Undo Management Advisor in Oracle?

816


Where do you use decode and case statements?

757


Explain the use of control file?

875


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2100


How to define default values for formal parameters?

787


How to use subqueries with the in operator using oracle?

836


what is dynamic SGA and static SGA

4065


What are the four Oracle system processes that must always be up and running for the database to be useable?

788


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1961


What privilege is needed for a user to query tables in another schema?

740