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

Answer / prna

SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)

Why do we need integrity constraints in a database?

0 Answers  

---

find out first highest salary?

10 Answers   Verinon Technology Solutions,

---

what are indexes..how many types of index's are there and what are they?

7 Answers   Green Info Solutions, TCS,

---

What is difference between Rename and Alias?

1 Answers  

---

What are dml statements in oracle?

0 Answers  

---

how to get the index id?

1 Answers   Cognizant, TCS,

---

How many types of database triggers exist?

0 Answers  

---

How to delete a user account in oracle?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

How to empty your oracle recycle bin?

0 Answers  

---

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---