Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

596

---

What are bind variables and why are they important?

552

---

Explain force logging feature in 9i.

615

---

Which rman command is used to create an exact replica of a database innew host?

599

---

What operator tests column for the absence of data?

605

---

System tablespace cant be exported from one database and imported into another why?

565

---

Explain the wait events in statspack report 'db sequential real'?

652

---

Explain the wait events in statspack report 'db scattered read'?

588

---

What is your favorite tool for day-to-day oracle operation?

553

---

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

558

---

What is difference between co-related sub query and nested sub query?

574

---

What is oracle full backup?

576

---

What is pga_aggregate_target?

576

---

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

610

---

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

634

---