Answer Posted / sarika desai

Normalization is a concept of Eliminating data redundancy,
Improve database performance & Index Improvement.

De-normalization is the process of attempting to optimize
the performance of a database by adding redundant data.

Can we write trigger for view?

1009

---

Mention the differences between substr and charindex in sql server.

1050

---

What is self contained multi valued query?

1014

---

What is precedence constraint?

983

---

What do you understand by sql server agent?

976

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

953

---

What is the use of builtinadministrators group in sql server? : sql server security

1048

---

Describe in brief authentication modes in sql server.

1027

---

What is data source view or dsv? : sql server analysis services, ssas

1000

---

How many full-text indexes can a table have?

974

---

How can you fetch alternate records from a table?

962

---

Explain different types of Normalization.

1831

---

What is right outer join in sql server joins?

1181

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1032

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

986

---