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 :con1hvar
What is the current value of the :con1hvar host variable?
A.
2
B.
3
C.
11
D.
30
B
0
0
NO MINVALUE
For an ascending sequence, the value is the START WITH value, or 1 if START WITH is not specified. For a descending sequence, the value is the minimum value of the data type associated with the sequence. This is the default.
0
0