Exit C2090-730 DB2 9 Family Fundamentals
Question 1 of 5
0% complete
Q1 Single choice

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 SELECTcx, cy FROM tab2

  • B

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

  • C

    INSERT INTO tab1 VALUES (SELECTcx, cy FROM tab2)

  • D

    INSERT INTO tab1 (c1, c2) VALUES (SELECTcx, cy FROM tab2)

Previous Next