Which of the following is true about Cascading triggers?

(i) Activating a trigger on execution of another trigger statement is called cascading of triggers
(ii) SQL error of -724 occurs when cascading reaches 17 and all the SQL changes made till this point will be rolled back
(iii) SQL error of -724 occurs when cascading reaches 17 and all the SQL changes made till this point will be committed
(iv) BEFORE triggers cannot be cascaded
(v) AFTER triggers cannot be cascaded

(i), (ii) and (iv)
(i), (iii) and (iv)
(i), (ii) and (V)
(i), (iii) and (v)
Verified Answer
Correct Option - a

To get all Infosys Certified Mainframe DB2 Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram