【C7】A．madeB．letC．sentD．urged

A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1

B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom

C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1

D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

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;（）

A.3

B.2

C.1

D.0

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp

B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1

C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp

D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom

A.INSERT INTO tab1 SELECT cx, cy FROM tab2

B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)

C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)

D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

A.CREATE TABLE tab1 OF myOBJ

B.CREATE TABLE myOBJ OF tab1

C.CREATE TABLE tab1 AS myOBJ

D.CREATE TABLE tab1 TYPE OF myOBJ

A.COL1 will accept NULL values and can be referenced in another table‘s foreign key specification.

B.COL1 will not accept NULL values and cannot be referenced in another tables foreign key specification.

C.COL1 will not accept NULL values and can be referenced in another tables foreign key specification.

D.COL1 will accept NULL values and cannot be referenced in another tables foreign key specification.

A．0

B．1

C．2

D．3

A.SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2

B.SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2

C.SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2

D.SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2