Multiple Choice
Identify the choice that best completes the statement or answers the question.

__A__ 1. All of the following would cause a trigger to fire, except ____. a. | BEFORE | c. | DELETE | b. | INSERT | d. | UPDATE |

__A__ 2. Which of the following indicates that the trigger is fired only once, regardless of the number of rows affected by the DML statement? a. | Statement level | c. | DML level | b. | Event level | d. | Row level |

__B__ 3. Which of the following statements is correct? a. | If multiple triggers exist on a table, the order in which the triggers will be fired can be set. | b. | A BEFORE statement level trigger will fire before a BEFORE row level trigger. | c. | If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written. | d. | Only one trigger can be constructed per table. |

__D__ 4. Row level options are only applicable for ____ events. a. | CREATE | c. | DECLARE | b. | INSERT | d. | UPDATE and DELETE |

__A__ 5. The default timing of a trigger is ____. a. | statement level | c. | row level | b. | system level | d. | header level |

__A__ 6. Which of the following events will cause the trigger to fire?
AFTER UPDATE OF orderplaced ON bb_basket a. | INSERT | c. | DELETE | b. | UPDATE | d. | AFTER |

__D__ 7. CURSOR basketitem_curIS SELECT idproduct, quantity, option1 FROM bb_basketitem WHERE idbasket = :NEW.idbasket;

In the code fragment above, which of the following represents the correlation identifier? a. | idproduct | c. | quantity | b. | bb_basketitem | d. | :NEW.idbasket |

__D__ 8. A(n) ____ table is one that is involved in a join and the keys of the original table are included in the keys of the resultant join. a. | mutating | c. | database | b. | system | d. | key-preserved |