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 snapshot is too old? Give and example for better understand.

1544

---

What is a trigger oracle?

1037

---

What are the differences between blob and clob in oracle?

1029

---

What is the data pump import utility?

968

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4479

---

What are dml statements in oracle?

1040

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

967

---

How many types of database triggers exist?

1064

---

What is a static data dictionary in oracle?

1024

---

What are the original export and import utilities?

1057

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2198

---

What is a proxy class?

967

---

Whether any commands are used for months calculation? If so, what are they?

1040

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1010

---

Why do we need oracle client?

885

---