Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 7275 Views
- I also Faced
- E-Mail Answers
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 download oracle database 10g xe?
What is a user role in oracle?
What are the composite date types in oracle?
How can I get column names from a table in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How will you identify oracle database software release?
How to shutdown your 10g xe server?
Can you assign multiple query result rows to a variable?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What is Network Database link ?
How do I know if oracle client is installed on windows?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Oracle General 
