Answer / praveen

Transaction must be Atomic (it is one unit of work and does
not dependent on previous and following transactions)

Consistent (data is either committed or roll back, no
“in-between” case where something has been updated and
something hasn’t)

Isolated (no transaction sees the intermediate results of
the current transaction)

Durable (the values persist if the data had been committed
even if the system crashes right after).

Can sql servers link to other servers like oracle?

0 Answers  

---

What is difference between standardization and normalization?

0 Answers  

---

Do comments need to go in a special place in sql server 2005?

0 Answers  

---

What do you mean by normalisation?

0 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

---

What is the main difference between ‘between’ and ‘in’ condition operators?

0 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What is Left Outer Join?

2 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---