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 there a tool to trace queries, like profiler for sql server?

1144

---

What is null value in oracle?

1100

---

Difference between the “verify” and “feedback” command?

1371

---

How to display row numbers with the records?

1084

---

How to export several tables together?

1049

---

How to create a table index?

1155

---

How to specify default values in insert statement using oracle?

1111

---

What are ddl statements in oracle?

1077

---

What is the usage of analyze command in oracle?

1095

---

What do you understand by database schema and what does it hold?

1232

---

How do I limit the number of oracle database connections generated by weblogic server?

1072

---

Is the After report trigger fired if the report execution fails ?

2917

---

What is primefaces used for?

1052

---

How to use an explicit cursor without open statements?

1057

---

Explain the different normalization forms?

1110

---