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.

Define right outer join?

931

---

What is difference between view and materialized view?

889

---

How to replace given values with null using nullif()?

924

---

Explain the third normal form(3nf)?

893

---

Explain the advantages of merge replication?

894

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1012

---

How you can change a cross join into an inner join?

909

---

Detail about the hardware which is supported by SQL server?

1009

---

How do you create a clustered index?

998

---

A trigger can reference objects outside the current database? State true or false.

945

---

What is difference between views and stored procedures?

928

---

Is oracle faster than sql server?

889

---

What is a user-defined function in the sql server and what is its advantage?

1044

---

What are the different authentication modes in sql server?

1051

---

What is database white box testing?

1077

---