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
您可能感兴趣的试卷
你可能感兴趣的试题
CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML) How many names will be returned for this XQuery?（）
A.0
B.1
C.2
D.3
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)
Given the following table definition:
STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）
A.UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%
B.UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%
C.UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'
D.UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%
The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT
101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote
105 ANNE -106 BOB A11
The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT
1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 -
After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno)
What is the result of the following query?（）
SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid
A. MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1
B. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1
C. MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3
D. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
A.The CONNECT statement
B.The first FETCH of a cursor
C.The BEGIN TRANSACTION statement
D.The first executable SQL statement
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 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)
A.Row
B.Table
C.Scalar
D.Column
A.CALL increase_salary('A00')
B.VALUES increase_salary('A00')
C.CALL increase_salary('A00', ?)
D.VALUES increase_salary('A00', ?)
The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James
T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405
If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）
A.DELETE ALL FROM tab01 FOR CURRENT OF csr01
B.DELETE FROM tab01 FOR CURRENT csr01 WITH RS
C.DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS
D.DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
A.REVOKE SELECT FROM user2 ON TABLE org.tab1
B.REVOKE SELECT ON TABLE org.tab1 FROM user2
C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2
最新试题
What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）
CREATE TABLE customer (cid BIGINT NOT NULL PRIMARY KEY, info XML) How many names will be returned for this XQuery?（）
On which of the following database objects may the SELECT privilege be controlled?（）
Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
The opening of cursor CSR01 produces the following result set:STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey JamesT100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405If this Fetch statement is executed: FETCH csr01 INTO :studnum, :firstname, :lastname, :class Which of the following DELETE statements will cause this row to be deleted?（）
Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）
Which of the following database objects can be used to raise an error if a table is updated?（）
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）