Why do we need to rebuild indexes?

1

---

What is the difference between media recovery & crash recovery?

1

---

What are the different types of backups that are available in oracle?

1

---

What are the different tools that are provided by oracle to assist performance monitoring?

1

---

What is the difference between restoring a database and recovering a database?

1

---

Can you list down the different components of physical and logical database structure?

1

---

What do you understand by redo log file mirroring?

1

---

What do you mean by sga and how is it different from pga?

1

---

What is a flashback query and when should it be used?

1

---

What is rac and what are the various benefits of using rac architecture?

1

---

How can we identify the resources for which the sessions are waiting?

1

---

What are the different optimizers that are used to optimize database?

1

---

What is a system tablespace and why do we need it?

1

---

What are the various benefits of using rac architecture?

1

---

How would you differentiate between cluster and grid?

1

---