How do you put database is archivelog mode, explain procedure?

343

---

Do you need a commit after ddl statements?

342

---

Explain the wait events in statspack report 'enqueue'?

337

---

What is the difference between raid 5 and raid 10? Which is better for oracle?

351

---

What is the difference between truncate and delete? Why is one faster?

336

---

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

312

---

What are bind variables and why are they important?

326

---

Explain force logging feature in 9i.

337

---

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

324

---

What operator tests column for the absence of data?

346

---

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

336

---

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

345

---

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

328

---

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

308

---

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

335

---