1Z0-909 practice question 3 of 15
Examine these commands which execute successfully: mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2)); mysql> CREATE TRIGGER subtotal…
Choose your answer, then check it against the explanation.
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?
Question 3 of 15
Keep practicing
Take the free 1Z0-909 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions