网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY5 Europe 6 North America 7 South AmericaWhich 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)


参考答案

更多 “ Given the following two tables:TAB1 C1 C21 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY5 Europe 6 North America 7 South AmericaWhich of the following SQL statements will insert all rows found in table TAB2 into table TAB1?()A.INSERT INTO tab1 SELECT cx, cy FROM tab2B.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) ” 相关考题
考题 Two-third of the cropland in the United States is planted in crops destined for export-to Europe, Asia, Africa and Latin America.() 此题为判断题(对,错)。

考题 You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following

考题 Given:When line 15 is reached, how many objects are eligible for the garbage collector?() A.0B.1C.2D.3E.4F.5

考题 Given:Whenline14isreached,howmanyobjectsareeligibleforthegarbagecollector?() A.0B.1C.2D.3E.4

考题 Given the following tables: CONTINENTS ID NAME COUNTRIES1 Antarctica 02 Africa 533 Asia 474 Australia 145 Europe 436 North America 237 South America 12REGION ID LOCATION 1 East 2 WestHow many rows would be returned using the following statement? SELECT location FROM continents, region()A.2B.7C.9D.14

考题 下列选项中,不能创建字典对象的语句是()。A.{'one':1, 'two':2, 'three':3}B.dict('one':1, 'two':2, 'three':3)C.dict([('one',1), ('two',2), ('three',3)])D.dict(zip(['one','two','three'], [1,2,3]))

考题 执行以下操作后,list_two的值是: list_one=[4,5,6] list_two=list_one list_one[2]=3A.[4,5,6]B.[4,3,6]C.[4,5,3]D.都不对

考题 下列数组定义中,错误的是A.char a[3][10]={"China","American","Asia"};B.int x[2][2]={1,2,3,4};C.float x[2][ ]={1,2,4,6,8,10};D.int m[][3]={1,2,3,4,5,6};

考题 4、下列选项中,不能创建字典对象的语句是()。A.{'one':1, 'two':2, 'three':3}B.dict('one':1, 'two':2, 'three':3)C.dict([('one',1), ('two',2), ('three',3)])D.dict(zip(['one','two','three'], [1,2,3]))