Answer Posted / srinivas

Normalization is the process of eliminating the duplicate , inconsistent data in the database..

As well denormalization is the process of introducing the redundancy to the data

What are the differences between user defined functions and stored procedures?

1004

---

Is it possible to create trigger on views?

934

---

What is difference between clustered and non clustered index?

919

---

What is data compression? : sql server database administration

916

---

How to see the event list of an existing trigger using sys.trigger_events?

1023

---

What is the difference between nvl and nvl2?

897

---

How to use copy and concatenate commands in SQL?

1063

---

what are candidate key, alternate key and composite key? : Sql server database administration

852

---

How to disable a login name in ms sql server?

1061

---

What command would you use to create an index?

982

---

Can we call stored procedure in trigger?

907

---

How to maintain a fill factor in existing indexes?

943

---

What are horizontal and vertical scaling?

170

---

What is bcp? When does it used?

920

---

Explain the types of indexes.

1111

---