Answer Posted / prithvi

select Max(sal) from emp

This will give us 1highest sal

Select Max (sal) from where sal <(select Max(sal) from emp)

Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))

What do you mean by redo log file mirroring?

553

---

What do you mean by merge in oracle and how can we merge two tables?

575

---

How to delete all rows a table in oracle?

619

---

What is bind variable in oracle 11g?

587

---

How to do a full database export?

631

---

---

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

581

---

What are the extensions used by oracle reports?

571

---

What is meant by recursive hints in oracle?

616

---

Explain the use of file option in exp command.

595

---

how to make an oracle object

1854

---

How to create a table in a specific tablespace?

539

---

What is recovery manager in Oracle?

589

---

List the types of joins used in writing subqueries?

573

---

What is archive log in Oracle?

595

---

What privilege is needed for a user to create tables in oracle?

548

---