多做题,通过考试没问题!

IBM认证考试

睦霖题库>其他计算机考试>IBM认证考试

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)
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题