Answer Posted / hari

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

Disadvantages of the indexes?

1125

---

What is the command to change the recovery model?

1047

---

What command is used to create a database in the sql server and how?

1180

---

Explain how you can deploy an SSRS report?

150

---

What happens if the update subquery returns no rows in ms sql server?

1124

---

What is merge statement?

1080

---

Explain difference between control flow and data flow?

965

---

What is the purpose of sql profiler in sql server? : sql server database administration

1107

---

How to convert binary strings into integers in ms sql server?

1029

---

What do you need to connect php to sql server?

1104

---

whats new about truncate in sql server 2008?

2502

---

What is the difference between count () and rowcount ()?

1026

---

What is the use of for clause?

1118

---

what is the difference between Delete and Truncate command in SQL

1147

---

Explain the properties of subqueries in sql server?

1082

---