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.

What is the direction of the dipole moment expected for hydrogen bromide?

1210

---

How does XDR'S use of the buffer paradigm make programming easier.

2559

---

Do you know what are triggers and rules?

1160

---

What is the difference between hcl acid and hcl gas?

1030

---

Convert 673 kelvin into degrees centigrade?

1084

---

How reactive is trimethylindium towards oxygen and water?

1133

---

What are the isomers of heptane?

1055

---

What types of insulators are there?

1060

---

Ten grams of dietary fat contains how many food calories?

965

---

Which is an example of a buffer system?

1133

---

What is an example of a polysaccharide?

1226

---

Myoglobin binds oxygen in what tissue in the human body?

1063

---

Two common isotopes of carbon are carbon-12 and carbon-14. How are atoms of the isotopes different from one another?

1024

---

Why chemists have not created a periodic table of compounds?

1057

---

What is the product of hcl zn?

1102

---