IBM(000-730)
单选题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
题目
SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
相似问题和答案
第1题：
A.SELECT * FROM t1 UNION SELECT * FROM t2
B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C.SELECT * FROM t1 INTERSECT SELECT * FROM t2
D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
第2题：
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)
第3题：
（ 22 ）在下列查询语句中，与
SELECT TABL* FROM TAB1 WHERE InStr([ 简历 ]," 篮球 ")<>0
功能相同的语句是（ ） 。
A ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like" 篮球 "
B ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like"* 篮球 "
C ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like"* 篮球 *"
D ） SELECT TAB1.* FROM TAB1 WHERE TAB1. 简历 Like" 篮球 *"
第4题：
In which of the following situations should correlation names be used?（）
- A、A table referenced in the FROM clause has no indexed column.
- B、The table referenced in the FROM clause has more than 200 columns.
- C、Two or more tables in the FROM clause have identical column names.
- D、The FROM clause contains two or more tables in the SELECT statement.
正确答案:C
第5题：
A.R1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1
B.R1 can send IP packets to R2, but R2 cannot send IP packets to R1
C.R2 no longer learns EIGRP routes from R1 for routes not connected to R1
D.R1 no longer replies to R2‘s Query messages
E.R2n o longer sends to R1 Query messages
第6题：
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.3
B.2
C.1
D.0
第7题：
A.SELECT UNIQUE dept FROM staff
B.SELECT DISTINCT dept FROM staff
C.SELECT (dept) UNIQUE FROM staff
D.SELECT (dept) DISTINCT FROM staff
第8题：
A.SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
B.SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
C.SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
D.SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
第9题：
Routers R1 and R2 are EIGRP neighbors. R1 has been configured with the eigrp stub connected command. Which of the following is true as a result？（）
- A、R1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1
- B、R1 can send IP packets to R2, but R2 cannot send IP packets to R1
- C、R2 no longer learns EIGRP routes from R1 for routes not connected to R1
- D、R1 no longer replies to R2's Query messages
- E、R2n o longer sends to R1 Query messages
正确答案:C,E
第10题：
Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）
- A、SELECT UNIQUE dept FROM staff
- B、SELECT DISTINCT dept FROM staff
- C、SELECT (dept) UNIQUE FROM staff
- D、SELECT (dept) DISTINCT FROM staff
正确答案:B