What are Triggers and Rules?

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


Please Help Members By Posting Answers For Below Questions

What is acid property in client server environment?

830


What is an object server in client server environment?

791


In RMI ,server object is first loaded into memory and then the stub reference is sent to the client. true or false?

873


Is dna organic?

779


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

767


Why chemists have not created a periodic table of compounds?

799


Explain what is the classification of clients?

905


Which is not a final product of the overall cell reaction in a hydrogen fuel cell?

778


Never found uncombined on earth, what element occurs abundantly in limestone, gypsum and fluorite?

821


What Network traffic is generated if one call connect on a socket of type SOCK – DGRAM?

2683


What is the difference between Server and Client side ?

863


How many significant figures are there in the number 0.0036?

809


Cellulose is a polymer of repeating units of what molecule?

756


What is a tp monitor in client server environment?

936


What are 3 facts on evaporation?

809