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

2 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

What is dbcc? : sql server DBA

0 Answers  

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

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

1 Answers  

---

how can you schedule a job in database?

0 Answers   Oracle,

---

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

1 Answers   STC,

---