A.JournalB.Task CenterC.Activity MonitorD.Command Line ……

单项选择题Which of the following tools can make recommendations for indexes and or MQTs to improve the performance of DB2 applications?（）

A.Design Advisor
B.Visual Explain
C.Performance Advisor
D.Configuration Assistant

单项选择题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/OS
B.DB2 Run-Time Client for z/OS
C.DB2 Connect Enterprise Edition for z/OS
D.z/OS Application Connectivity to DB2 for z/OS and OS/390

单项选择题A trigger can be created on which of the following objects?（）

A.View
B.Catalog Table
C.Stored Procedure
D.Global Temporary Table

单项选择题Which of the following supports the XML data type?（）

A.A unique index
B.A composite index
C.A check constraint
D.A generated column

单项选择题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 UPDATABLE
B.Define the column MAINID as a PRIMARY KEY
C.Define the column MAINID as a FOREIGN KEY
D.Define an UPDATE trigger on table TABLEX