What are the types of indexes?

0 Answers  

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

What do you know about normalization and de- normalization?

0 Answers  

---

---

write an SQL query to list the employees who joined in the month of January?

0 Answers   Agilent, Amdocs,

---

What is the difference between delete and truncate statements?

0 Answers  

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

What are the source of constraints?

0 Answers  

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

List some major differences between triggers and stored procedures?

0 Answers  

---

How to get the definition of a stored procedure back?

0 Answers  

---