From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

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

1 Answers   CSC,

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

Name three advisory statistics you can collect.

1 Answers  

---

how can you create a user-defined lock?

0 Answers   Oracle,

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

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  

---

How can you rebuild an index?

6 Answers  

---

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

0 Answers   Patni,

---