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

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

Question Posted / guest

1 Answers
4563 Views
Sierra Atlantica, I also Faced
E-Mail Answers

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

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers KPIT,

What is sql and its types?

0 Answers

What is the size of partition table?

0 Answers

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers iGate,

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers L&T,

What found sql?

0 Answers

What are the two characteristics of a primary key?