Sign Up Login


  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

Which is faster view or stored procedure?

0 Answers  

What is sql exception?

0 Answers  

How to trace the errors in pl/sql block code?

5 Answers   TCS,

What do you know by pl/sql cursors?

0 Answers  

Explain dml and ddl?

0 Answers  




Why indexing is needed?

0 Answers  

What is the maximum number of rows in sql table?

0 Answers  

What does the sign mean in sql?

0 Answers  

What is where clause in sql?

0 Answers  

Advantages and disadvantages of stored procedure?

0 Answers  

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

What are stored procedures in mysql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories