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

554

---

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

566

---

List five most important parameter in 9i affecting performance?

570

---

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

565

---

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

574

---

What does the no logging option do? Why would we be careful of using it?

602

---

Tell me about standby database? What are some of the configurations of it?

569

---

When using oracle export/import what character set concerns might come up? How do you handle them?

597

---

Which date function is used to find the difference between two dates?

582

---

How do you install statspack?

692

---

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

550

---

How do you analyze table partition using oracle provided package?

523

---

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

768

---

What is oracle partial backup?

587

---

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

578

---