Answer Posted / rajendra prasad reddy penumall

these two are SQL concepts

TRigger is a special type of stored procedure that
automatically takes effect when the data in a specified
table is modified.
triggers invoked in response to an INSERT,UPDATE OR DELETE
STATEMENT EXECUTED.
TRIGGERS are used to handle some exceptional conditions
if u r moving data 40 MB into data base,But data base having
only 30 mB free space then the trigger fires automatically
and the entire transaction automativcally roll backs.

Rules:
Rules are database objects used to enforce data integrity.
this object bound to column or userdefined data types.
to ensure that only valid values are allowed to insert in
to columns.

so trigger acts automatically nad rollbacks the transaction
when error is occured.

rule is used to enforce data integrity on a column or user
defined data type.

are you clear if you want any clarification please mail to
me.

Tell me what are the three types of sql database server architecture?

1064

---

Give full information about infrared technology, like applications, advantages, disadvantages?

919

---

Which are not carbonate minerals?

974

---

What gas was discovered by daniel rutherford in 1772 by placing a mouse inside a bell jar, removing all the oxygen in the jar by burning a substance in it, and demonstrating the asphyxiation of the mouse?

913

---

How do you separate the colors of ink?

989

---

what is an isomer?

1053

---

What are the properties of carbohydrates?

1062

---

Which has the same electron configuration as neon?

954

---

What is the difference between Server and Client side ?

1117

---

What is distributed or remote presentation?

2374

---

If you had a choice debugging deadlock problem or a livelock Problem, which would you choose? Why ? How would you proceed?

3435

---

The ideal fuel for fuel cell use is?

1106

---

What colorless liquid was originally produced from the distillation of wood and is often referred to as wood alcohol?

1015

---

What are the isomers of heptane?

1016

---

What is meant by Asymmetrical protocols?

2560

---