Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()

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)

时间:2022-09-12 01:17:18 所属题库:IBM(000-730)题库

相似题目