Answer Posted / alka

select min(salary)
from(select salary
from emp
order by salary desc
)
where rownum <=3

What is index in Oracle?

590

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1806

---

What happens to the indexes if a table is recovered?

577

---

Point out the difference between user tables and data dictionary?

539

---

What are the execution control statements in oracle?

601

---

---

How to use "out" parameter properly?

628

---

Explain alias?

711

---

What is dual table oracle?

527

---

What are the ways tablespaces can be managed and how do they differ?

1616

---

How to import one table back from a dump file?

591

---

What to do if dba lost the system password?

597

---

How to start your 10g xe server?

594

---

Difference between open_form and call_form in oracle.

677

---

How to create an oracle database manually?

568

---

How do I spool in oracle?

541

---