O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 17 Triggers

Lab 17.1 ▪ Self-Review Answers

A1:
Questions Answers Comments
1) C 
A2:
Questions Answers Comments
2) B Once a trigger has been defined on a particular table, it fires implicitly when a triggering event occurs. By default, when a trigger is created it is also enabled. Once you disable a trigger, it will not fire when a triggering event occurs.
A3:
Questions Answers Comments
3) A The WHEN condition controls when a trigger should fire. If such a condition does not evaluate to TRUE, the trigger will not fire.
A4:
Questions Answers Comments
4) C 
A5:
Questions Answers Comments
5) D A trigger fires before or after a triggering event: INSERT, UPDATE, or DELETE. A SELECT operation is not a triggering event. It reads information ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required