问题:单选题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 supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column...
问题:单选题Which of the following will begin a new unit of work?()A The CONNECT statementB The first FETCH of a cursorC The BEGIN TRANSACTION statementD The first executable SQL statement...
问题:Which object may be used during query optimization to improv...
问题:单选题A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR ...
问题:单选题When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?()A An error will occur.B Data passed between the client and the server is encrypted.C User IDs and passwords are passed ...
问题:单选题Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a...
问题:单选题Which of the following describes the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository...
问题:单选题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 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 ...
问题:单选题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...
问题:单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?()A Any row inserted or updated through view V1 must meet the conditi...
问题:单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?()A UDTB TriggerC PackageD Access plan...
问题:单选题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...
问题:单选题A UDT is a data type which:()A must contain unique values.B cannot be CAST to other data types.C is created using the CREATE DISTINCT command.D contains a value that was automatically calculated from values in other columns....
问题:单选题Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?()A Design AdvisorB Visual ExplainC Performance AdvisorD Configuration Assistant...
问题:单选题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...
问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column...
问题:单选题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 ...