问题:单选题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 ...
Saturday, July 15, 2023
问题:单选题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 ...
Tuesday, March 19, 2024
问题:单选题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...
Monday, November 27, 2023
问题:单选题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 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 ...
Saturday, April 13, 2024
问题:单选题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...
问题:单选题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...
Wednesday, January 3, 2024
问题:单选题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 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...
Saturday, March 30, 2024
问题:单选题Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?()A SELECT UNIQUE dept FROM staffB SELECT DISTINCT dept FROM staffC SELECT (dept) UNIQUE FROM staffD SELECT (dept) DISTINCT FRO...
Friday, September 22, 2023
问题:单选题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 resources can be explicitly locked?()A RowB PageC TableD Column...
Wednesday, May 31, 2023
问题:单选题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...
问题:单选题For which of the following is a data warehouse optimized?()A Backup and recoveryB TransactionsC SecurityD Queries...
Wednesday, February 22, 2023
问题:单选题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...
Monday, February 27, 2023
问题:单选题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 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...
问题:单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column...
Thursday, January 26, 2023
问题:单选题Which of the following best describes how locks are used in DB2?()A To maintain control of updated rows for commit processingB To ensure only committed changes are altered by another applicationC To allow two applications to update the same row of data...