Answer Posted / amit sutar

select min(salary)

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

where rownum<=5;

List out the components of logical database structure of oracle database.

1042

---

How many memory layers are in the oracle shared pool?

1191

---

What happens to the current transaction if a ddl statement is executed?

1021

---

What is literal?

1016

---

What is bulk collect in oracle?

1004

---

How is it different from a normal table?

1041

---

How to import one table back from a dump file?

1032

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2197

---

How many anonymous blocks can be defined?

1193

---

How to open a cursor variable?

1045

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2263

---

What are the differences between char and varchar2 in oracle?

1181

---

What is the use of aggregate functions in oracle?

1027

---

What is an oracle user account?

1000

---

How do we get field details of a table?

983

---