What is a “trigger”?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

123. What is a “trigger”?

Answer1
It’s a piece of sql that is activitied when a certain event happens.

Answer2
Trigger is also set of sql comments written together same as stored procedure but the difference is that trigger will be activated each & everytime addition or deletion takes place.

(Continued on next question...)

Other Job Interview Questions

• Talk about “Exception Handling” in PL/SQL?
• What are the different types of Record Groups?
• (On UNIX) When should more than one DB writer process be used? How many should be used?
• What is a cluster Key?
• Is it possible to split the print reviewer into more than one region?
• With which function of summary item is the compute at options required?
• Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
• Explain the use of setting GLOBAL_NAMES equal to TRUE.
• What is strip sources generate options?
• How do I display row number with records?
• More...