Answer Posted / padmapriya

Noramalization is process of breaking the information into
well defined tables which should follow some rules. There
are 5 Normal forms available. Each one having a separate
rule.
1NF-Avoid redundant data
2NF-All coulms except primary key column should be related
to the primary key column
3NF,4NF and 5NF - I'dont remember , if any one knows please
reply

How can I check that whether automatic statistic update is enabled or not?

1050

---

How to divide query output into multiple groups with the group by clause in ms sql server?

1053

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1022

---

How data can be copied from one table to another table?

959

---

Do you know spatial data types - geometry and geography in sql server 2008?

1054

---

What is format parameter in ssrs?

148

---

What is subreport?

144

---

Explain collation?

1073

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1131

---

Define the one-to-one relationship while designing tables.

915

---

What is the significance of null value and why should we avoid permitting null values?

998

---

What are number line correlation administrators will use while working with a subquery?

1186

---

Can sql server 2016 run on windows 7?

925

---

what is the difference between count(*) and count(1) ?

1091

---

Explain transaction server distributed transaction?

990

---