How do you analyze the tables

1

---

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

506

---

How can be determining the size of the log files?

531

---

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

519

---

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?

538

---

How can you tell if a tablespace has excessive fragmentation?

551

---

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

536

---

What is a database instance?

541

---

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

502

---

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

595

---

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

534

---

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

516

---

How can you find your id on a system?

518

---

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

498

---

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?

529

---