可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

A sequence was created with the DDL st


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?()

  • A20
  • B25
  • C50
  • D55
参考答案
参考解析:
分类:IBM(000-730)题库
相关推荐

1、A table was created using the followi

A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 ...

2、A sequence was created with the DDL st

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully ex...

3、A view is created with the following s

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWha...

4、A view is created with the following s

A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access t...

5、You create a Web site with membership

You create a Web site with membership and personalization enabled. You must use an existing CRM database for storing the membership information....

6、You work with a newly created database

You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tun...