Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 7638 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 |
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Explain the difference between replace() and translate() functions in oracle?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is dynamic proxy?
Explain what are the uses of rollback segment?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to define a procedure inside another procedure?
how to get last monday of a month?
How to add a new column to an existing table with a default value?
What are the different types of failures that occur in Oracle database?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Difference between an implicit & an explicit cursor.?
Oracle General 
