Do you know What are Triggers and Rules?
Submitted by: Administratorthese 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Client Server General Job Interview Questions And Answers
Top Client Server General Questions
☺ | What are the benefits obtained by using the Client Server oriented TP Monitors Client Server applications? |
☺ | What happens in your design if two or more clients access the same file? What happens if a client crashes before closing a file? |
☺ | What is Remote Procedure Call? |
☺ | Explain what is Upsizing, down-sizing? |
☺ | Explain What are called Non-GUI clients, GUI Clients and OOUI Clients? |
Top Client Server Categories
☺ | Client Server Architecture Interview Questions. |
☺ | Client Server General Interview Questions. |