Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 8296 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 |
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
How do you find current date and time in oracle?
Is oracle a programming language?
Is the After report trigger fired if the report execution fails ?
What is the implicit cursor in oracle?
Please explain joins in oracle?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
Which Oracle App Is Most Popular One ?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
wirte the syntax of update query?
How to name query output columns in oracle?
Oracle General 
