Answer Posted / vimal p.s

A trigger is a SQL procedure that initiates an action when
an event (INSERT, DELETE or UPDATE) occurs. Triggers are
stored in and managed by the DBMS.Triggers are used to
maintain the referential integrity of data by changing the
data in a systematic fashion. A trigger cannot be called or
executed; the DBMS automatically fires the trigger as a
result of a data modification to the associated table.
Triggers can be viewed as similar to stored procedures in
that both consist of procedural logic that is stored at the
database level. Stored procedures, however, are not event-
drive and are not attached to a specific table as triggers
are. Stored procedures are explicitly executed by invoking
a CALL to the procedure while triggers are implicitly
executed. In addition, triggers can also execute stored
procedures.

Explain the usage of floor function in sql server.

1021

---

What is normalization process?

1238

---

Does group by or order by come first?

998

---

Explain what you mean by 3 tier architecture.

1127

---

What is data source document?

1089

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1170

---

How do you create an execution plan?

1007

---

What is change data capture (cdc) feature?

1122

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1005

---

What are user-defined functions (udfs) in sql server?

1051

---

How can we remove orphan records from a table?

1029

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2137

---

What command must you use to include the not null constraint after a table has already been created?

1234

---

Explain active/passive and active/active cluster configurations?

1109

---

In what version of sql server were synonyms released?

1000

---