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 term for the ph at which an amino acid or protein becomes electrically neutral?

994

---

what is meant by MultiServer?

2218

---

What is a database server in client server environment?

1059

---

what is meant by transparency of location servers?

2793

---

What is the only known substance for which there is no triple point?

926

---

What is meant by Asymmetrical protocols?

2552

---

can you show you the organic structure of cetearyl alcohol and tell me what organic family it is?

1058

---

What makes a molecule into an organic molecule?

991

---

What is structured query langauge (sql)?

1040

---

How do you prepare a solution of 1 m hcl?

990

---

How to send 10,000 mail?

1020

---

How many valence electrons does each of the elements in the periodic table have?

1026

---

What is ciprofloxacin hcl used for what type?

936

---

Ten grams of dietary fat contains how many food calories?

920

---

What are the isomers of heptane?

1010

---