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.

Explain the commands in sql server?

0 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

why we use cursor?

4 Answers   CarrizalSoft Technologies, Melstar, TCS,

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

Tell me what is a linked server?

0 Answers  

---

How to sort the query output with order by clauses in ms sql server?

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---