How would you pass hints to the sql processor?

999

---

Explain two easy sql optimizations.

1026

---

How do I write a cron which will run a sql query and mail the results to agroup?

998

---

Why is sql*loader direct path so fast?

1116

---

Name three sql operations that perform a sort.

1022

---

What is the use of the drop option in the alter table command?

603

---

How do you use automatic pga memory management with oracle 9i and above?

592

---

Which function is used to find the largest integer less than or equal to aspecific value?

568

---

Explain procedure to change characterset of a database.

645

---

What is oracle archived redo log?

600

---

what does the no logging option do? Why would we use it?

558

---

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

570

---

List five most important parameter in 9i affecting performance?

572

---

How can you tell if an index on particular table is used or not used in 9i?

569

---

You see a wait on lms process in statspack, what does that mean?

579

---