If you see the value for reloads is high in the estat library cache report is this a matter for concern?

577

---

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

540

---

What parameters control copy latches?

554

---

What is difference between logical standby database and physical standby database?

617

---

What is the easiest method to create a file on unix?

533

---

What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?

523

---

What is explain plan and how is it used?

548

---

What is the purpose of the grep command?

2049

---

How do you set up tablespaces during an oracle installation?

560

---

You have taken a manual backup of a datafile using os. How rman will know about it?

523

---

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

539

---

How many control files should you have? Where should they be located?

537

---

What are four common errors found in an alert .log?

507

---

How do you generate file output from sql?

573

---

You see multiple extents in the temporary tablespace. Is this a problem?

552

---