Which of the following statements is True about mutating tables?
A) A table in an UPDATE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the UPDATE includes a subquery.
B) A table in a DELETE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DELETE includes a subquery.
C) A table in an INSERT statement that fires a row level trigger affecting the same table is not considered a mutating table unless the INSERT includes a subquery.
D) A table in a DROP statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DROP includes a subquery.
Correct Answer:
Verified
Q23: A(n) _ is a table that is
Q24: Which of the following events will cause
Q25: The default timing of a trigger is
Q26: DDL events include all of the following,
Q27: Row level options are only applicable for
Q29: All of the following would cause a
Q30: CURSOR basketitem_curIS
SELECT idproduct, quantity, option1
FROM bb_basketitem
WHERE idbasket
Q31: Which of the following indicates that the
Q32: _ triggers refer to database triggers that
Q33: The statement _ correctly deletes a trigger.
A)
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents