网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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)
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 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)” 相关考题
考题
以下程序运行后的输出结果是______。 main() { char c1，c2； for(c1='0',c2='9'；c1＜c2；c1++,c2--) printf("%c％c"，c1,c2)； printf("\n")； }A．918245765B．893478654C．786584763D．918273645
考题
有以下程序: includemain(){char c1='1',c2='2';c1=getchar();c2=getchar();putchar(c
有以下程序： # include＜stdio.h＞ main() {char c1='1',c2='2'； c1=getchar();c2=getchar();putchar(c1);putchar (c2)； } 当运行时输入：a＜回车＞后，以下叙述正确的是 ______。A．变量c1被赋予字符a，c2被赋予回车符B．程序将等待用户输入2个字符C．变量c1被赋予字符a，c2中仍是原有字符2D．变量c1被赋予字符a，c2中将无确定值
考题
Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()
A.SELECT * FROM t1 UNION SELECT * FROM t2B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C.SELECT * FROM t1 INTERSECT SELECT * FROM t2D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
考题
Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query? SELECT count(*) FROM tab2;（）A.3B.2C.1D.0
考题
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
考题
有以下程序includemain(){charc1='1',c2='2';c1=getchar();c2=getchar();putchar(c1)
有以下程序#include＜stdio. h＞main(){ char c1='1'，c2='2'； c1=getchar()； c2=getchar()； putchar(c1)； putchar(c2)；} 当运行时输入：a＜回车＞ 后，以下叙述正确的是A．变量c1被赋予字符a，c2被赋予回车符B．程序将等待用户输入第2个字符C．变量c1被赋予字符a，c2中仍是原有字符2D．变量c1被赋予字符a，c2中将无确定值
考题
有以下程序:include main( ) {char c1='1',c2='2';c1=getchar();c2=getchar();putcha
有以下程序:#include ＜stdio, h＞main( ) { char c1='1'，c2='2'； c1=getchar()；c2=getchar()；putchar(c1)；putchar(c2)； } 当运行时输入：a＜回车＞后，以下叙述正确的是( )。A．变量c1被赋予字符a，c2被赋予回车符B．程序将等待用户输入第二个字符C．变量c1被赋予字符a，c2中仍是原有字符2D．变量c1被赋予字符a，c2中将无确定值
考题
有以下程序 #include main（） { char c1=’1’，c2=’2’； c1=getchar（）； c2=getchar（）； putchar（c1）； putchar（c2）； } 当运行时输入：a回车后，以下叙述正确的是（）A、变量C1被赋予字符a，c2被赋予回车符B、程序将等待用户输入第2个字符C、变量c1被赋予字符a，c2中仍是原有字符2D、变量c1被赋予字符a，c2中将无确定值
考题
Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）A、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)B、 CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2) C、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)D、 CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1）
考题
将电容器C1（100V、20uF）和C2（160V、20uF）串联接到250V电压上，则（）。A、C1、C2均正常工作B、 C1击穿，C2正常工作C、C1、C2均击穿D、C1正常工作，C2击穿
考题
STP算法中，网桥按照如下的方法确定最优的配置消息，假设有两条配置消息C1和C2（）A、如果C1的RootID小于C2的RootID 则C1优于C2B、如果C1和C2的RootID相同，但C1的RootPathCost大于C2，则C1优于C2C、如果C1和C2的RootID和RootPathCost相同，但C1的TransmitID大于C2，则C1优于C2D、如果C1和C2的RootID、RootPathCost和TransmitID都相同，但C1的PortID小于C2，则C2优于C1
考题
若A1=2，B1=3，C1=A1+B1，若想让C2单元格显示5，则可以用下列（）方法。A、在C2里输入“=C1”B、选中C1复制，在C2上选择“粘贴”C、选中C1复制，在C2上选择“选择性粘贴/数值”D、用填充柄从C1拖到C2
考题
Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）A、2B、7C、9D、14
考题
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）A、SELECT * FROM T1 MINUS SELECT * FROM T2B、SELECT * FROM T1 EXCEPT SELECT * FROM T2C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D、SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
考题
Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）A、SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2B、SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2C、SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2D、SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
考题
Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）A、SELECT * FROM t1 UNION SELECT * FROM t2B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C、SELECT * FROM t1 INTERSECT SELECT * FROM t2D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
考题
Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); What is the result of the following query? SELECT count(*) FROM tab2;（）A、3B、2C、1D、0
考题
Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）A、SELECT * FROM tab1 INNER JOIN tab2 ON c1=cxB、SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxC、SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxD、SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
考题
单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）A
SELECT * FROM t1 UNION SELECT * FROM t2B
SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C
SELECT * FROM t1 INTERSECT SELECT * FROM t2D
SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
考题
单选题Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）A
SELECT * FROM T1 MINUS SELECT * FROM T2B
SELECT * FROM T1 EXCEPT SELECT * FROM T2C
SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D
SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
考题
单选题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 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)
考题
单选题Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）A
CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3) B
CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3) C
CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1) D
CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)
考题
单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）A
2B
7C
9D
14
考题
单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）A
2B
7C
9D
14
考题
单选题Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）A
SELECT * FROM tab1 INNER JOIN tab2 ON c1=cxB
SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxC
SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxD
SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx
热门标签
最新试卷