单选题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（）ASELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2BSELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2CSELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2DSELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2
单选题
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 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
参考解析
解析：
暂无解析
相关考题：
（ 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" 篮球 *"
Given the following two tables:TAB1 R1A A A B B C C D E TAB2 R2A A B B C C DWhich 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
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 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)
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 staffB.SELECT DISTINCT dept FROM staffC.SELECT (dept) UNIQUE FROM staffD.SELECT (dept) DISTINCT FROM staff
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 R1B.R1 can send IP packets to R2, but R2 cannot send IP packets to R1C.R2 no longer learns EIGRP routes from R1 for routes not connected to R1D.R1 no longer replies to R2‘s Query messagesE.R2n o longer sends to R1 Query messages
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 R1B、R1 can send IP packets to R2, but R2 cannot send IP packets to R1C、R2 no longer learns EIGRP routes from R1 for routes not connected to R1D、R1 no longer replies to R2's Query messagesE、R2n o longer sends to R1 Query messages
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.
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 staffB、SELECT DISTINCT dept FROM staffC、SELECT (dept) UNIQUE FROM staffD、SELECT (dept) DISTINCT FROM staff
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 function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?A、SELECT TABLE(EMPLIST()) FROM EMPLOYEEB、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
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 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)
单选题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 tab2BINSERT 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)
单选题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?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 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（）ASELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2BSELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2CSELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 r2DSELECT 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?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * 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;（）A3B2C1D0
单选题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 tab2BINSERT 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)
多选题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？（）AR1 can learn EIGRP routes from R2, but R2 cannot learn EIGRP routes from R1BR1 can send IP packets to R2, but R2 cannot send IP packets to R1CR2 no longer learns EIGRP routes from R1 for routes not connected to R1DR1 no longer replies to R2's Query messagesER2n o longer sends to R1 Query messages
单选题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?（）ASELECT * FROM T1 MINUS SELECT * FROM T2BSELECT * FROM T1 EXCEPT SELECT * FROM T2CSELECT * FROM T2 UNION EXCEPT SELECT * FROM T1DSELECT * FROM T1 NOT EXISTS SELECT * FROM T2
单选题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?（）ASELECT * FROM tab1 INNER JOIN tab2 ON c1=cxBSELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cxCSELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cxDSELECT * 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?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)