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.

How to replace given values with null using nullif()?

1040

---

How to add the custom code in Report?

129

---

When we should use @@error?

1030

---

How can you set the threshold at which sql server will generate keysets asynchronously?

1049

---

How to use values from other tables in update statements in ms sql server?

1180

---

When to use Inner join & when to use subquery?

1234

---

What is plan freezing?

1009

---

Name and describe few console utilities for ssrs?

288

---

application server is slow what may be the problem

2270

---

Will the writetext statement activate a trigger?

1152

---

Why use update_statistics command in sql server?

1111

---

How to store and query spatial data?

1046

---

Differentiate between a primary key and a unique key.

1114

---

Write down the syntax and an example for create, rename and delete index?

1023

---

What is difference between count (*) and count 1?

970

---