当前分类： IBM(000-730)
问题：单选题Which of the following privileges permits a user to update the comment on a sequence?（）A CONTROLB UPDATEC USAGED ALTER...
查看答案
问题：单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statemen...
问题：单选题Which of the following supports the XML data type?（）A A unique indexB A composite indexC A check constraintD A generated column...
问题：单选题The following statements: CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE...
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD 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...
问题：单选题Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）A Define a UNIQUE constraint on the columns NEXT_STEPNO...
问题：单选题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 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 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 ...
问题：单选题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 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...
问题：单选题A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement ...
问题：单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
问题：单选题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 ...
问题：单选题On which of the following database objects may the SELECT privilege be controlled?（）A SequenceB SchemaC GroupD View...
问题：单选题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 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...
问题：单选题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...
