Answer Posted / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

Explain the use of control file?

654

---

What are the execution control statements?

619

---

What is null value in oracle?

636

---

What is Reduced List of Values?

1704

---

Why is oracle so popular?

561

---

---

What is oracle instant client?

566

---

What are nested tables?

671

---

How can I get column names from a table in oracle?

534

---

What is a read write transaction in oracle?

604

---

What is meant by an index?

619

---

What is a system tablespace and when it is created?

558

---

What is system tablespace?

632

---

How to list all tables in your schema?

609

---

How can I introduce multiple conditions in like operator?

553

---

Explain what are the uses of rollback segment?

584

---