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.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Is benzene a polar molecule?
What is the ph of a solution with a hydronium ion concentration of 1 x 10-8 moles/dm3?
Do you know what are triggers and rules?
What is the concentration, in parts per billion, of a solution that contains 1 microgram of solute per liter?
What are all the base services provided by the os in client server environment?
What are the different client/server processing styles?
What are the cons of eating organic foods?
What element does the symbol au stand for?
Convert the molecular structure of the hydrocarbon c5h12 into its straight-chain condensed structural formula?
Which has the same electron configuration as neon?
Is thin client different from web client?
What is message oriented middleware (mom) in client server environment?
What is the secondary structure of proteins?
Why chemists have not created a periodic table of compounds?
Two common isotopes of carbon are carbon-12 and carbon-14. How are atoms of the isotopes different from one another?
