Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

---

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  

---

What is a correlated sub-query? : sql server DBA

0 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

How would you force a log switch?

4 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---