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 is the difference difference between procedure and packages

2 Answers   3i Infotech, Oracle,

How do you update a value in sql?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

What will happen after commit statement ?

2 Answers  




what is the difference between binary_integer and pls_integer

2 Answers   TCS,

How does sql profiler work?

0 Answers  

What is autocommit sql?

0 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

What are all the different normalization?

0 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

What are the indexing methods?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories