可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Given the following two tables: 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?()

  • AINSERT INTO tab1 SELECT cx, cy FROM tab2
  • BINSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
  • CINSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
  • DINSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
参考答案
参考解析:
分类:IBM(000-730)题库
相关推荐

1、The table is()for two people

The table is()for two peopleAnot big enoughBbig not enoughCbig enough not

2、Given the following 

Given the following output what course of action should be undertaken for a long ...

3、Given the following requirements: Cre

Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is ...

4、Given the following two tables: TAB1

Given the following two tables:TAB1 C1 C2A 11 B 12 C 13 TAB2 CX CYA 21 C 22 D 23The following results are desired:C1 C2 CX CYA 11 A 21 ...

5、Given the following table definitions

Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O'Neal 6008Carter 50DEPA...

6、Given the following 

Given the following six method names:(1)addListener(2)addMouseListener (3)setMouseListener(4)deleteMouseListener(5)rem...