Answer Posted / anand

SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2

is there a tool to trace queries, like profiler for sql server?

599

---

Explain the use of tables option in exp command.

591

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1616

---

What are operators in oracle?

525

---

Why oracle is used?

578

---

---

Explain a data segment?

648

---

What is the sid in oracle?

536

---

In which language oracle has been developed?

641

---

What is analyze command used for?

575

---

What is a synonym? What are its various types?

622

---

What is logical backup in oracle?

574

---

What are data pump export and import modes?

609

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1437

---

What are the different types of synonyms?

592

---

What are the benefits of ordbms?

619

---