what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

What is full form of XP ?

42 Answers   Cap Gemini, Infosys, Microsoft, Oracle, Reliance,

---

How many index keys possible for a table

6 Answers  

---

How would you add a section to a table?

0 Answers  

---

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

---

What is the difference between constraints and triggers?

9 Answers   Wipro,

---

What does it mean to normalize a database and why would you do it?

0 Answers  

---

How many databases instances are there in sql server 2000?

0 Answers  

---