单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column...
Thursday, January 26, 2023
单选题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...
Saturday, April 13, 2024
单选题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 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...
Tuesday, July 25, 2023
单选题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 ...
Thursday, August 17, 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 are types of routine objects?()A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
Wednesday, March 6, 2024
单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column...
Consider the following table called EMPLOYEES: ID FIRSTNAME...
Saturday, September 17, 2022
单选题The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab...
Friday, November 11, 2022
单选题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
单选题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...
单选题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 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...
Saturday, March 30, 2024
单选题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 ...
单选题Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?()A SELECT * FROM tab1 INNER ...
单选题Which of the following describes the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository...