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

What is a trigger and what are its types?

1329

---

How to assign a table row to a record variable?

1092

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

---

What privilege is needed for a user to connect to oracle server?

1034

---

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2319

---

What are a cluster and non-cluster index?

1064

---

What are the limitations of check constraint?

1075

---

How to convert a string to a date in oracle database?

1100

---

What is archive log in Oracle?

1183

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

---

What are the different types of modules in oracle forms?

1048

---

What are triggers in oracle?

1097

---

What is enter substitution variable in oracle?

1095

---

In the oracle version 9.3.0.5.0, what does each number shows?

1344

---

material view and view disadvantages?

1124

---