Answer Posted / anitha

select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2

How to display employee records who gets more salary than the average salary in the department?

1067

---

What is the use of file param in imp command?

1165

---

What are the uses of a database trigger?

994

---

What are joins, explain all types of joins?

2299

---

What is the oracle implicit cursor?

1066

---

What is the difference between sharding and partitioning?

986

---

How to define a cusotmer as a supplier in ORACLE R12

2232

---

How can we view last record added to a table?

1040

---

How to list all indexes in your schema?

1093

---

What is a data dictionary and how can it be created?

1152

---

How to define an anonymous procedure without variables?

1107

---

Where do you use decode and case statements?

996

---

What is backup in Oracle?

1006

---

What is an oracle transaction?

1147

---

does the query needs a hint to access a materialized view?

1859

---