describe and contrast a trigger and a procedure.



describe and contrast a trigger and a procedure...

Answer / Rishi Kumar Lohiya

A trigger is a database object that automatically executes in response to certain events such as insert, update, or delete operations. Triggers are used for data consistency and integrity checking, whereas procedures are a set of SQL statements that can be called and executed multiple times with different parameters. Procedures are used for complex tasks such as calculations, conversions, and error handling.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

Can you export a table along with partition?

1 Answers  


Where is the data stored in a database?

1 Answers  


Define union all operator and union.

1 Answers  


What is different keys in dbms?

1 Answers  


Mention some disadvantages of query?

1 Answers  


What are the steps in creating a database?

0 Answers  


How do you copy a database?

1 Answers  


Dept wise avrage salary

2 Answers   HCL, IBM, TCS,


What is a distributed database system?

1 Answers  


Define view, sequence and index in DBMS.

1 Answers   HAL,


What's the difference between star and snow flake schema?

1 Answers  


When is a .FMB file extension is created in Forms 4.5 ?

1 Answers  


Categories