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.

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

What does Master database contains?

0 Answers   Abacus,

---

How to use subqueries with the in operators in ms sql server?

0 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

---

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

To find second largest salary in Employee table

17 Answers   CSS,

---

which one will take 1st priority in case of insert statement and select statement???

2 Answers   HCL,

---