当前分类： IBM(000-730)
问题：单选题An application needs to store a 5 MB JPEG image in a DB2 table. Which data type should be specified for the column that will be used for storing the image?（）A GRAPHICB BINARYC IMAGED BLOB...
查看答案
问题：单选题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 resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space...
问题：单选题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...
问题：单选题Which of the following is NOT true about XML columns?（）A Data can be retrieved by SQL.B Data can be retrieved by XQuery.C XML columns must be altered to accommodate additional parent and child relationships.D Access to any portion of an XML document ca...
问题：单选题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...
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD Column...
问题：单选题If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）A Rollback the transaction in both applications.B Rollback the transaction in one of the two applications.C D...
问题：单选题How does DB2 protect the integrity of indexes when data is updated?（）A Locks are acquired on the data.B Locks are acquired on index keys.C Locks are acquired on index pages.D Locks are acquired on index pointers....
问题：单选题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...
问题：单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal o...
问题：单选题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...
问题：单选题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 are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
问题：单选题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 ...
问题：单选题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...
问题：单选题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 of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
