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
Which of the instruments would typically be used to measure the smallest quantities of mass:
An atom has 18 protons and 22 neutrons. What is its mass number?
What kind of bond does hcl have?
How do you test a gas to see if it was hydrogen?
Another name for heavy water is?
I have source having single column C1 RAM KRISHNA I have to load that data in to one target . that target contain two columns C1 and C2 I want the out put like C1 C2 RAM KRISHNA that means in 1st column RAM and Second column Krishna ok by using informatica only . single space in between ram krishna in soucre column ok?
What is acid property in client server environment?
What are the two broad classes of middleware in client server environment?
What are super servers in client server environment?
can you show you the organic structure of cetearyl alcohol and tell me what organic family it is?
How do you separate the colors of ink?
What element does the symbol au stand for?
According to bronsted-lowry definition, a base is?
What types of insulators are there?
What is the octet rule in chemistry?
