IBM(000-730) 题目列表
单选题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?（）ADefine the column MAINID as NOT UPDATABLEBDefine the column MAINID as a PRIMARY KEYCDefine the column MAINID as a FOREIGN KEYDDefine an UPDATE trigger on table TABLEX
单选题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?ASELECT TABLE(EMPLIST()) FROM EMPLOYEEBSELECT TABLE(EMPLIST()) AS t FROM EMPLOYEECSELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEEDSELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
单选题Which of the following describes the objects of a DB2 database and their relationships?（）AInstanceBTable spaceCSystem catalogDSchema repository
单选题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 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 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?（）ASELECT e.id, d.deptname FROM employee e, department d WHERE e.id 4BSELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id 4CSELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id 4DSELECT 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 supports the XML data type?（）AA unique indexBA composite indexCA check constraintDA generated column
单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）ACLOBBBLOBCHierarchicallyDRows and columns
单选题Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?（）ADB2 Express EditionBDB2 Personal EditionCDB2 Workgroup Server EditionDDB2 Enterprise Server Edition
单选题How does DB2 protect the integrity of indexes when data is updated?（）ALocks are acquired on the data.BLocks are acquired on index keys.CLocks are acquired on index pages.DLocks are acquired on index pointers.
单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）ADECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLEBDECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSCCREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSDCREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
单选题Which of the following is a characteristic of a sequence?（）AA sequence will never generate duplicate valuesBThe MAXVALUE of a sequence can be equal to the MINVALUECIt is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroDWhen a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries
单选题Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）ADB2 for i5/OSBDB2 Runtime ClientCDB2 Connect Enterprise EditionDDB2 for i5/OS SQL Development Kit
单选题Which of the following is a characteristic of a schema?（）AForeign key references cannot cross schema boundaries.BA DB2 user must be created before a schema with the same name can be created.CIf no schema is specified when an object is created, the default schema PUBLIC is used.DA schema enables the creation of multiple objects in a database without encountering namespace collisions.