单选题Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?()A LIST DB DIRECTORYB LIST DCS DIRECTORYC LIST NODE DIRECTORYD LIST ACTIVE DATABASES...
Thursday, January 26, 2023
单选题A trigger can be created on which of the following objects?()A ViewB Catalog TableC Stored ProcedureD Global Temporary Table...
Saturday, July 29, 2023
单选题Which of the following supports the XML data type?()A A unique indexB A composite indexC A check constraintD A generated column...
Tuesday, March 19, 2024
单选题What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?()A CheckB RangeC ReferentialD Informational...
Thursday, August 17, 2023
单选题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 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 describes the objects of a DB2 database and their relationships?()A InstanceB Table spaceC System catalogD Schema repository...
单选题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 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 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 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 ...
单选题Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?()A Task CenterB Command EditorC Developer WorkbenchD Command Line Processor...
单选题To which of the following resources can a lock be applied?()A RowB AliasC BitmapD Column...
单选题Which of the following privileges permits a user to update the comment on a sequence?()A CONTROLB UPDATEC USAGED ALTER...
单选题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...
单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?()A UDTB TriggerC PackageD Access plan...
Monday, January 22, 2024
单选题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...
Tuesday, July 25, 2023
单选题Which of the following provides a logical grouping of database objects?()A ViewB TableC SchemaD Buffer pool...