Answer Posted / sreejith s t

LIKE operator performs pattern matching

Explain difference between control flow and data flow?

955

---

Explain what is meant by replication of database?

1025

---

Explain some stored procedure creating best practices or guidelines?

923

---

Which tcp/ip port does the sql server run on? How can it be changed?

1046

---

Why use triggers?

1002

---

How is table type constraint applied to a table?

970

---

What is normalization? Explain its different types?

1079

---

Explain the functionalities that views support?

1105

---

Explain ms sql server reporting services vs crystal reports?

907

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

972

---

Why it is recommended to avoid referencing a floating point column in the where clause?

953

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

943

---

Explain the steps needed to create a scheduled job?

917

---

what information is maintained within the msdb database? : Sql server administration

954

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1013

---