How do you analyze the tables

1

---

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

586

---

How can be determining the size of the log files?

619

---

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

603

---

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

619

---

How can you tell if a tablespace has excessive fragmentation?

636

---

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

633

---

What is a database instance?

632

---

Which is the best option used to move database from one server to another serve on same network and why?

581

---

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

701

---

How can you determine the number of sqlnet users logged in to the unix system?

606

---

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

623

---

How can you find your id on a system?

602

---

What os user should be used for the first part of an oracle installation (on unix)?

587

---

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

608

---