Answer Posted / abdul quadir parihar

Normalization is the process of decomposition of complex
data in to simple way.

Denormalization is basically applied in the case the
database is over-normalised and no. of joins required to
fetch the data are too much. It is a purposeful redundancy
of some of the data to avoid the overhead of joins.

Explain the architecture of ms sql reporting service?

970

---

What is the difference between char, varchar and nvarchar?

1076

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1246

---

Do you know the isolation level that sql server support?

1003

---

Difference between primary key and clustered index?

1061

---

What happens if we shrink log file in sql server?

1031

---

What is the process of indexing?

1051

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1187

---

Differentiate between SQL and ORACLE joins and write their syntax.

1071

---

What is the Difference Between Primary and Foreign Key?

1064

---

What are the dmvs? : sql server database administration

1119

---

List the types of recovery model available in sql server?

971

---

What is Replication?

1106

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1099

---

What are trace flags and mention a few common trace flags used with sql server?

1137

---