Answer / Mahavir Singh

{"when_an_index_is_appropriate": [n "When frequently executed queries require data from a specific column or set of columns.n "When the query uses WHERE, ORDER BY, or GROUP BY clauses to filter or sort data.n "When multiple tables are joined and the JOIN condition is on an indexed column.n "When the table contains a large number of rows and queries often retrieve only a small subset of the data."]}

When would you use a before or after trigger?

1 Answers  

---

Is a primary key unique?

1 Answers  

---

How to use copy and concatenate commands in SQL?

1 Answers   Amdocs,

---

What is the benefit of normalization?

1 Answers  

---

What is a unique index?

1 Answers  

---

From where can you change the default port?

3 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

What are partitioned views?

1 Answers  

---

Which are the third-party tools used in sql server and why would you use them?

1 Answers  

---

What are the four main query statements?

7 Answers   Wipro,

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

How do I view views in sql server?

1 Answers  

---