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

What are acid properties of transaction?

555

---

What is the architecture of ms sql reporting service?

530

---

What are the new features of sql server 2008 r2 reporting service?

110

---

What do you understand by recursive stored procedure?

524

---

Give me a SQL Query to find out the second largest company?

694

---

---

query processing

1740

---

What is reference section?

501

---

Give main differences between "Truncate" and "Delete".

583

---

What is dml command?

553

---

How to execute a stored procedure in ms sql server?

554

---

What does asynchronous call backs means?

625

---

Can we install sql server 2016 on windows 7?

677

---

What are data regions?

92

---

what are constraints? : Sql server database administration

532

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

583

---