What are Triggers and Rules?
- 2 Answers
- 11307 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yamuna.g
Triggers are special user defined actions usually in the
form of stored procedures that are automatically invoked by
the server based on data related events. It can perform
complex actions and can use the full power of procedural
languages.
A rule is a special type of trigger that is used to perform
simple checks on data.
| Is This Answer Correct ? | 8 Yes | 1 No |
Why do some medications contain hcl?
Explain what is infrared technology?
According to bronsted-lowry definition, a base is?
Think about the hardware limit on system calls. How can a system designer add additional system call without changing the hardware?
Is thin client different from web client?
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?
What are the differences between organic and inorganic chemistry?
What is the only known substance for which there is no triple point?
What are the benefits obtained by using the Client Server oriented TP Monitors Client Server applications?
4 Answers CarrizalSoft Technologies, CSC, New Horizons,
Tell me what are the three types of sql database server architecture?
The risks while testing client - server application?
What makes a molecule into an organic molecule?
Client Server Architecture 
