问题:单选题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 MAINID as a FOREIGN KEYD Define an UPDATE trigger on table TABLEX
Saturday, April 13, 2024
问题:单选题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 the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?()A SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4B SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4C SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4D SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4
问题:单选题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
问题:单选题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
Tuesday, March 19, 2024
问题:单选题Which of the following describes the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository
Saturday, July 15, 2023
问题:单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column
问题:单选题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
Monday, November 27, 2023
问题:单选题Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?()A DB2 for z/OSB DB2 Run-Time Client for z/OSC DB2 Connect Enterprise Edition for z/OSD z/OS Application Connectivity to DB2 for z/OS and OS/390
问题:单选题For which of the following is a data warehouse optimized?()A Backup and recoveryB TransactionsC SecurityD Queries
Wednesday, February 22, 2023
问题:单选题Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?()A CREATE UNIQUE INDEX idx_partno ON parts(part_no)B CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)C CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)D CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)
问题:单选题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 mgridA MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1B MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1C MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3D MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1
Saturday, October 15, 2022
问题:单选题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 csr01B DELETE FROM tab01 FOR CURRENT csr01 WITH RSC DELETE * FROM tab01 WHERE CURRENT csr01 WITH CSD DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR
Wednesday, May 31, 2023
问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column
Thursday, January 26, 2023
问题:单选题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)
问题:单选题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
问题:单选题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?()A TableB ColumnsC Table and AliasD Columns and Alias
Monday, January 22, 2024
问题:单选题Which of the following strings can be inserted into an XML column using XMLPARSE?()A <employee/>B <?xml version='1.0' encoding='UTF-8' ?>C <!DOCTYPE hello SYSTEM 'hello_world.dtd'>D <x xmlns:ibmcert='http://www.ibm.com/certify'>
Saturday, July 29, 2023
问题:单选题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