A.LIST DB DIRECTORYB.LIST DCS DIRECTORYC.LIST NODE DIRE……

单项选择题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

A.UDT
B.Trigger
C.Package
D.Access plan

单项选择题An Alias can be an alternate name for which DB2 object?（）

A.Sequence
B.Trigger
C.Schema
D.View

单项选择题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 my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）

A.20
B.25
C.50
D.55

单项选择题A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）

A.2
B.3
C.11
D.30

单项选择题Which of the following is a characteristic of a sequence?（）

A.A sequence will never generate duplicate values
B.The MAXVALUE of a sequence can be equal to the MINVALUE
C.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
D.When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries