Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

How would you go about increasing the buffer cache hit ratio?

2 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

---

What command would you use to create a backup control file?

2 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

what is a user-defined lock?

0 Answers   Oracle,

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

Explain what partitioning is and what its benefit is.

2 Answers  

---