Answer Posted / himanshu

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

946

---

How exception handling is done in advance pl/sql?

920

---

Can we use views in stored procedure?

972

---

define data blocks ? : Sql dba

932

---

Explain what is sql*plus?

1088

---

Is crud a cuss word?

975

---

What is the difference between sum and count in sql?

938

---

In pl/sql, what is bulk binding, and when/how would it help performance?

938

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1035

---

What are the benefits of stored procedures?

1000

---

Why does sql need a server?

992

---

What are the dml statements?

1097

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2070

---

What are the types of join and explain each?

989

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1161

---