单选题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
题目
单选题
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)