当前分类： 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?（）A Define the column MAINID as NOT UPDATABLEB Define the column MAINID as a PRIMARY KEYC Define the column ...
查看答案
问题：单选题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 a typical data warehouse query?（）A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?...
问题：单选题Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSE...
问题：单选题Which of the following is a characteristic of a sequence?（）A A sequence will never generate duplicate valuesB The MAXVALUE of a sequence can be equal to the MINVALUEC It is not possible to create a sequence that generates a constant since the INCREMENT...
问题：单选题Application A holds an Update lock on a single row and application B is trying to read that row. If both applications are using isolation level UR, which of the following will occur?（）A Application B will read the row.B Applications A and B will cause ...
问题：单选题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'...
问题：单选题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?（）A DB2 for i5/OSB DB2 Runtime ClientC DB2 Connect Enterprise Editi...
问题：单选题Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）A MQTB TriggerC Read Only CursorD Stored Procedure...
问题：单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?（）A When view V1 is createdB Each time the REFRESH VIEW v1 statement is executed...
问题：单选题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 ...
问题：单选题Which of the following is true of an index used to support a UNIQUE constraint?（）A It must have the UNIQUE attribute.B It cannot be created explicitly by the user.C It must have the UNIQUE and CLUSTER attributes.D It must have the UNIQUE WHERE NOT NULL...
问题：单选题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...
问题：单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A A check constraint on the EMPLOYEE tableB...
问题：单选题Which of the following is a characteristic of a schema?（）A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the d...
问题：单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）A The cursor is only protected from updates and deletes by concurrent applications.B The row is only protected from positioned updates and delet...
问题：单选题If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?（）A COL1 will accept NULL values and can be referenced in another table's foreign key specification.B COL1 will not accept NULL values and cannot be re...
问题：单选题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...
问题：单选题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...
