Describe the different type of Integrity Constraints
supported by ORACLE ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prna
SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)
Is This Answer Correct ? | 1 Yes | 1 No |
How to declare a local variable?
Why do we use coalesce function in oracle?
what is the bitmap index?
How can Oracle users be audited?
How to create a new oracle data file?
what is the exact definition for pointer?
What is Library Cache in Oracle?
What is partitioned table in Oracle?
What happens if the imported table already exists?
candidate key is subset of super key but not vice-verse explain
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)