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
What are the types of partitions in oracle?
What is oracle analytical function?
How to assign values to variables?
Can you drop an index associated with a unique or primary key constraint?
What is an external table?
What is Undo Management Advisor in Oracle?
Where do you use decode and case statements?
Explain the use of control file?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to define default values for formal parameters?
How to use subqueries with the in operator using oracle?
what is dynamic SGA and static SGA
What are the four Oracle system processes that must always be up and running for the database to be useable?
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
What privilege is needed for a user to query tables in another schema?