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 select some rows from a table in oracle?
What is the usage of analyze command in oracle?
What suggestions do you have to reduce the network traffic?
Explain database link?
What is the disadvantage of User defind function?
What is Undo Management Advisor in Oracle?
12 RULES OF RDBMS
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What are the predefined tablespaces in a database?
How to connect to the server with user account: sys?
What is blob datatype?