1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Which one is the Best approach to put code, among Triggers
and Procedures? Explain?

Question Posted / guest


Which one is the Best approach to put code, among Triggers and Procedures? Explain?..

Answer / gogu s k

For security and audit related events and to record changes
done to database, triggers are best.

For applying business rules and performing dml operations
procedures are ideal.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

difference between cursor and procedure in a package

3 Answers   PCS,

What is the order of sql select?

0 Answers  

What is bulk collections?

2 Answers  

Explain 3 basic parts of a trigger.

0 Answers  

What is the need of merge statement?

0 Answers  




what is d diff between grant,commit,rollback n savepoint

1 Answers  

what is meant by forward declaration in functions?

4 Answers   TCS,

what are all the different normalizations? : Sql dba

0 Answers  

Can you call pl/sql package functions from within a fast formula?

0 Answers  

What is a crud api?

0 Answers  

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

How do you remove duplicate records from a table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories