Oracle Exam 1Z0-909 Topic 9 Question 17 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 17
Topic #: 9

Examine these commands which execute successfully:

mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));

mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income

FOR EACH ROW SET @subtotal = subtotal + NEW.amount;

Which is true for the income table?

AThe trigger activates after any row has been inserted into the table.

BThe trigger body set causes trigger activation.

CThe trigger activates after any row in the table has been updated.

DExecution of an insert statement causes the trigger to activate.

Show Suggested Answer

Suggested Answer: D

by Antione at Mar 23, 2023, 11:52 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!