Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 8166 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 |
What is cluster Key ?
How to select some columns from a table in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Does facebook use oracle?
What is a Tablespace?
why pl sql doesn't support retrieving multiple records
How to create an oracle database manually?
What is tns name?
Whats the benefit of dbms_stats over analyze?
How to retrieve data from an cursor to a record?
Please explain joins in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Oracle General 
