Answer Posted / 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 recovery models in sql server 2000?

927

---

What are the triggers in sql?

1021

---

What is a rownum?

894

---

Explain different types of index?

989

---

What is the command used to recompile the stored procedure at run time?

1018

---

What is change data capture (cdc) in sql server 2008?

981

---

What is fill factor and pad index?

956

---

What is stored in the mssqlsystemresource database? : sql server database administration

988

---

what is the difference between Delete and Truncate command in SQL

1086

---

What is a covering index?

921

---

What is the openxml statement in sql server?

1012

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

936

---

What is subquery explain with example?

1010

---

How to create user messages with print statements in ms sql server?

943

---

What is the default port for SQL Server over a firewall?

1032

---