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)
Answer:A
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)
