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.

Explain what are the database objects? : SQL Server Architecture

1086

---

Explain try...catch with sql server?

1025

---

Why olap is used?

977

---

What is join and name different type of joins?

1051

---

Why I am getting this error when dropping a database in ms sql server?

1078

---

What are data resources?

918

---

Explain the microsoft sql server delete command?

1025

---

What is the difference between mysql and sql server?

1028

---

What is difference between index seek vs. Index scan?

1156

---

How many levels of sp nesting are possible?

1029

---

Can we call stored procedure in trigger?

951

---

Can we add an identity column to decimal datatype?

1002

---

how can you check the level of fragmentation on a table? : Sql server administration

985

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

945

---

Explain stored procedure?

1060

---