单项选择题
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
