A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to

题目

A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?()

A.Sequence

B.Table Function

C.Identity Column

D.INSTEAD OF Trigger


相似考题
更多“A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ”相关问题
  • 第1题:

    This restaurant is rather more ________ than that one.

    A.expensively

    B.expensiveness

    C.expensive

    D.expense


    正确答案:C
    解析:本题考查以名词 expense 为词根的形容词的用法。从系动词 is 来看,空格处用的是形容词的比较结构,所以用 expensive(“昂贵的”)。其他三个选项分别是:expense-名词(“昂贵”);expensively-副词(“昂贵地”);expensiveness(“昂贵性”)。句意:“这家餐馆比那家贵多了。”

  • 第2题:

    下列选项中,采用指定表的所有字段名的方式向表Student中添加id为1,name为”小王”的记录值的SQL语句是()

    A.INSERT INTO Student(“id”,”name”) VALUES(1,”小王”)

    B.INSERT INTO Student(id,name) VALUES(1,’小王’)

    C.INSERT INTO Student VALUES(1,”小王”)

    D.INSERT INTO Student(id,”name”) VALUES(1,”小王”)


    INSERT 语句中指定所有字段名

  • 第3题:

    设置多列布局的属性值为()。

    A.columns-width

    B.column-count

    C.column-gap

    D.column-rule


    A 解析:Columns属性返回或设置一个值,以决定控件是水平还是垂直滚动以及如何显示列中的项目。Columns属性值为0时,控件为垂直滚动;Columns属性等于1时,则列表框呈多行多列显示: Columns属性值大于1时,为水平滚动,Columns属性值的数量决定在控件中的可见宽度内显示列的数量。Columns属性用来确定列表框的列数。

  • 第4题:

    由以下语句创建的表有种子字段,请正确组合插入语句,可不分先后。CREATE TABLE Customer(id int IDENTITY PRIMARY KEY,Customer varchar(40))()

    A.INSERT INTO Customer

    B.SET IDENTITY_INSERT Customer ON

    C.VALUES(3,’garden shovel’)

    D.(id,Customer)


    参考答案:A, B, C, D

  • 第5题:

    WordCloud类的generator方法的功能是:

    A.generate(text)在text路径中生成词云

    B.generate(text)生成词云的宽度为text

    C.generate(text)生成词云的高度为text

    D.generate(text)由text文本生成词云


    D

  • 第6题:

    在标量数据可视化实例中,generate_values(n, grid.point_data.scalars.range)方法中属性n表示什么?

    A.等值面的数量

    B.等值面的颜色映射

    C.等值面的范围

    D.等值面实体的透明度


    等值面的数量