Answer Posted / mallikarjun

select max(sal) from emp
where sal < select max (sal)from emp






Mallikarjun

Explain the use of rows option in exp command.

575

---

What is snapshot is too old? Give and example for better understand.

1088

---

What happens to the indexes if a table is recovered?

568

---

What is bulk copy or bcp in oracle?

598

---

What is data block in Oracle?

610

---

---

How to loop through data rows in the implicit cursor?

536

---

Explain mutating triggers.

561

---

How many file formats are supported to export data?

645

---

Can we protect our pl/sql source code?

568

---

How a tablespace is related to data files?

573

---

Differentiate between function and procedure in oracle.

553

---

What is the difference between alert log file and tarce file ?

1626

---

What are the execution control statements in oracle?

589

---

What is define in oracle?

555

---

How to login to the server without an instance?

612

---