Answer Posted / devipriyanka

Types of Triggers

* DML(data manipulation language) triggers (SQL Server
2000- 80.0)
o AFTER triggers (Only Tables)
o INSTEAD OF triggers (Tables or Views)
* DDL(data definition language) triggers (SQL Server
2005- 90.0)
* SQLCLR triggers (SQL Server 2005- 90.0)

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1094

---

How can we rewrite sub-queries into simple select statements or with joins?

967

---

What are a database and a data warehouse?

1015

---

Explain about Joins?

980

---

How to download and install microsoft sql server management studio express?

1026

---

How to see the event list of an existing trigger using sys.trigger_events?

1062

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1046

---

What are the drawbacks of reporting in ssrs?

149

---

How to change server name in sql server?

1172

---

What are different types of table joins?

993

---

What is a recursive stored procedure in sql server?

1156

---

What is an sql server agent?

1052

---

Mention what are the different types of ssrs reports?

150

---

What is cube dimension? : sql server analysis services, ssas

998

---

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

1032

---