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

What are the packages in pl sql?

0 Answers  

How to access the current value and next value from a sequence?

6 Answers  

how to create object in plsql

3 Answers   Microsoft,

What is pl sql commands?

0 Answers  

What is numeric function sql?

0 Answers  




I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

What is Data Concarency and Consistency?

1 Answers  

what is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

What are stored procedures in mysql?

0 Answers  

Why is nosql good?

0 Answers  

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

For more SQL PLSQL Interview Questions Click Here
Categories