C2090-730 Web TestEngine demo

Exit VCEDump C2090-730 DB2 9 Family Fundamentals
Question 8 of 46
0% complete
Q8 Single choice

Given the following statements:

CREATE TABLE tab1 (col1 INT);
CREATE TABLE tab2 (col1 INT);
CREATE TRIGGER trig1 AFTER UPDATE ON tab1
REFERENCING NEW AS new1
FOR EACH ROW MODE DB2SQL
INSERT INTO tab2 VALUES(new1.col1);
INSERT INTO tab1 VALUES(2),(3);

What is the result of the following query?

SELECT count(*) FROM tab2;

Sign in to mark questions

Sign in to save marked questions and return to this demo.

Sign in