Answer Posted / anand

3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005

DDL and LOGON are used to administrator related tasks

What is row_number () and partition by in sql server?

1134

---

Can you tell me about the concept of ER diagrams?

1121

---

What is a join in sql? What are the types of joins?

1189

---

Define views.

1068

---

What are trace files?

1004

---

How to apply cascading referential integrity in place of triggers?

1090

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

990

---

What is de-normalization in sql database administration? Give examples?

1027

---

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

212

---

How do I shrink an ldf file?

1038

---

What is query cost in sql server?

1037

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1042

---

How to create a user name in a database?

1102

---

Tell me what are the advantages of using stored procedures?

1062

---

What is difference between after and before?

1189

---