1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

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

0 Answers   Patni,

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

what is incremental checkpoint?

1 Answers   CTS,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

---

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

7 Answers   TCS,

---