How do you analyze the tables

1

---

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

289

---

How can be determining the size of the log files?

276

---

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

291

---

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?

308

---

How can you tell if a tablespace has excessive fragmentation?

315

---

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

281

---

What is a database instance?

283

---

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

254

---

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

317

---

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

285

---

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

297

---

How can you find your id on a system?

276

---

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

273

---

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?

293

---