Answer Posted / arijit

donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));

What is partitioned table in Oracle?

1184

---

What is data type in oracle?

1118

---

defination of bitmap index

2117

---

How do we get field detail of a table?

1077

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1897

---

What do you know about normalization? Explain in detail?

949

---

How to use subqueries in the from clause in oracle?

1110

---

What is the implicit cursor in oracle?

1102

---

Explain compound trigger in oracle?

1033

---

How to unlock the sample user account in oracle?

1013

---

How to convert characters to numbers in oracle?

1063

---

What is the maximum limit on the number of columns in a table?

1082

---

What is the minimum client footprint required to connect c# to an oracle database?

1088

---

What happens if you lost a data file?

1034

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

---