can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

---

---

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

4 Answers  

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

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,

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---