Describe the different type of Integrity Constraints
supported by ORACLE ?
- 2 Answers
- 7686 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the arithmetic operations?
what is reindexing?
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?
What is SQL Tuning Advisor in Oracle?
What is the difference between a primary key & a unique key?
 How to use an oracle sequence generator in a mapping?
What is recovery manager(rman) backup in Oracle?
What is a trigger oracle?
Explain the use of tables option in exp command.
types of indexes and the rationale behind choosing a particular index for a situation.
List the types of joins used in writing subqueries?
What is sequence?
What are a collation and state the different types of collation sensitivity?
How much memory your 10g xe server is using?
Briefly explain what is literal? Give an example where it can be used?
