Answer / arun anoop m

1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.

What are the types of database recovery models?

0 Answers   HCL,

---

How except clause is differs from not in clause?

0 Answers  

---

How to find Duplicate Records In table?

0 Answers   HCL,

---

syntax and example for bitmap index in sql???

1 Answers  

---

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 a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

What is the difference between osql and query analyzer?

0 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

What is the purpose of linked server configuration in sql server?

0 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---