当前分类： IBM(000-730)
问题：单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）A An application process acquires at least a share lock on the current row of every cursor.B Any row that is read during a unit of work cannot be changed by other applic...
查看答案
问题：单选题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 Connectivi...
问题：单选题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...
问题：单选题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...
问题：单选题Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）A DB2 will no longer allow updating the value of IDCOL1 in TABLE1.B When inserting a row in TABLE2, t...
问题：单选题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); W...
问题：单选题Which of the following supports the XML data type?（）A A unique indexB A composite indexC A check constraintD A generated column...
问题：单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
问题：单选题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 IN...
问题：单选题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 ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）A The next value wil...
问题：单选题Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）A JournalB Task CenterC Control CenterD Activity Monitor...
问题：单选题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 ...
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD Column...
问题：单选题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 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 ...
问题：单选题Which kind of non-sourced UDF can be created so that it only returns a single value?（）A RowB TableC ScalarD Column...
问题：单选题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 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 tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A Control CenterB Development CenterC Developer WorkbenchD Stored Procedure Builder...
