问题：单选题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 SELEC...
查看答案
问题：单选题Which of the following is a feature of a unit of work?（）A It applies to a single data server.B It is a recoverable sequence of operations.C Its value can be queried from the system catalog tables.D It begins when the application connects to the data se...
问题：单选题Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A REVOKE ACCESS ON DATABASE FROM USER bobB REVOKE CONNECT ON DATABASE FROM USER tomC REVOKE tom FROM ACCESS ON DATABASE BY USER bobD REVOKE tom FROM CO...
问题：单选题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 ...
问题：单选题If an application issues the same query more than once in the same Unit of Work, which isolation level will not permit this application to see additional rows inserted by other applications?（）A Read Stability (RS)B Repeatable Read (RR)C Uncommitted Rea...
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD Column...
问题：单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE...
问题：单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space...
问题：单选题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 ...
问题：单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）A CLOBB BLOBC HierarchicallyD Rows and columns...
问题：单选题What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?（）A CheckB RangeC ReferentialD Informational...
问题：单选题Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A Define the column MAINID as NOT UPDATABLEB Define the column MAINID as a PRIMARY KEYC Define the column ...
问题：单选题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?（）A A check constraint on the EMPLOYEE tableB...
问题：单选题Which of the following supports the XML data type?（）A A unique indexB A composite indexC A check constraintD A generated column...
问题：单选题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 ...
问题：单选题Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and t...
问题：单选题Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?（）A DB2 Express EditionB DB2 Personal EditionC DB2 Workgroup Server EditionD DB2 Enterprise Server Edition...
问题：单选题Which of the following describes the model used by the Geodetic Extender?（）A Flat earthB 3-D SquareC TrapezoidalD Round earth...
问题：单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
