单选题An Alias can be an alternate name for which DB2 object?（）A SequenceB TriggerC SchemaD View

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

Sequence

B

Trigger

C

Schema

D

View

相似考题

1.Which best describes an inline view? ()A. a schema objectB. a subquery that can contain an ORDER BY clauseC. another name for a view that contains group functionsD. a subquery that is part of the FROM clause of another query

2.Which of the following is a characteristic of a schema?()A.Foreign key references cannot cross schema boundaries.B.A DB2 user must be created before a schema with the same name can be created.C.If no schema is specified when an object is created, the default schema PUBLIC is used.D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.

3.On which of the following database objects may the SELECT privilege be controlled?()A.SequenceB.SchemaC.GroupD.View

4.Which of the following database objects can be used to raise an error if a table is updated?()A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题An Alias can be an alternate name for which DB2 object?（）A SequenceB TriggerC SchemaD View”相关问题

  • 第1题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()

    A.Table

    B.Columns

    C.Table and Alias

    D.Columns and Alias


    参考答案：A

  • 第2题：

    An Alias can be an alternate name for which DB2 object?()

    A.Sequence

    B.Trigger

    C.Schema

    D.View


    参考答案：D

  • 第3题：

    Because objects（ ） data and implementation, the user of an object can view the object as a black box that provides services.

    A.encapsulate
    B.inherit
    C.connect
    D.refer

    答案：A
    解析：

  • 第4题：

    An Alias can be an alternate name for which DB2 object?（）

    • A、Sequence
    • B、Trigger
    • C、Schema
    • D、View

    正确答案:D

  • 第5题：

    A stored procedure object is created into which DB2 object?（）

    • A、Alias
    • B、Schema
    • C、Package
    • D、Routine Space

    正确答案:B

  • 第6题：

    Which of the following database objects can be used to raise an error if a table is updated?（）

    • A、Package
    • B、Trigger
    • C、Stored Procedure
    • D、Informational Constraint

    正确答案:B

  • 第7题：

    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

    • A、Table
    • B、Columns
    • C、Table and Alias
    • D、Columns and Alias

    正确答案:A

  • 第8题：

    Which object privileges can be granted on a view? （）

    • A、none
    • B、DELETE, INSERT,SELECT
    • C、ALTER, DELETE, INSERT, SELECT
    • D、DELETE, INSERT, SELECT, UPDATE

    正确答案:D

  • 第9题：

    单选题
    Which best describes an inline view?（）
    A

    a schema object

    B

    a subquery that can contain an ORDER BY clause

    C

    another name for a view that contains group functions

    D

    a subquery that is part of the FROM clause of another query


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Which object privileges can be granted on a view? （）
    A

    none

    B

    DELETE, INSERT,SELECT

    C

    ALTER, DELETE, INSERT, SELECT

    D

    DELETE, INSERT, SELECT, UPDATE


    正确答案： B
    解析： 暂无解析

  • 第11题：

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

    Sequence

    B

    Trigger

    C

    Schema

    D

    View


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    Which HttpSession method stores an object in a session？（）
    A

     put（String name. Object value）

    B

     set（String name. Object value）

    C

     setAttribute（String name. Object value）

    D

     putAttribute（String name. Object value）

    E

     addAttribute（String name. Object value）


    正确答案： A
    解析： 暂无解析

  • 第13题：

    A stored procedure object is created into which DB2 object?()

    A.Alias

    B.Schema

    C.Package

    D.Routine Space


    参考答案：B

  • 第14题：

    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

  • 第15题：

    Which object may be used during query optimization to improve the performance for a subset of SELECT queries?（）

    • A、MQT
    • B、Trigger
    • C、Read Only Cursor
    • D、Stored Procedure

    正确答案:A

  • 第16题：

    On which of the following database objects may the SELECT privilege be controlled?（）

    • A、Sequence
    • B、Schema
    • C、Group
    • D、View

    正确答案:D

  • 第17题：

    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

  • 第18题：

    Which of the following is a characteristic of a schema?（）

    • A、Foreign key references cannot cross schema boundaries.
    • B、A DB2 user must be created before a schema with the same name can be created.
    • C、If no schema is specified when an object is created, the default schema PUBLIC is used.
    • D、A schema enables the creation of multiple objects in a database without encountering namespace collisions.

    正确答案:D

  • 第19题：

    Which HttpSession method stores an object in a session？（）

    • A、 put（String name. Object value）
    • B、 set（String name. Object value）
    • C、 setAttribute（String name. Object value）
    • D、 putAttribute（String name. Object value）
    • E、 addAttribute（String name. Object value）

    正确答案:C

  • 第20题：

    Which best describes an inline view?（）

    • A、a schema object
    • B、a subquery that can contain an ORDER BY clause
    • C、another name for a view that contains group functions
    • D、a subquery that is part of the FROM clause of another query

    正确答案:D

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    A stored procedure object is created into which DB2 object?（）
    A

    Alias

    B

    Schema

    C

    Package

    D

    Routine Space


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following is a characteristic of a schema?（）
    A

    Foreign key references cannot cross schema boundaries.

    B

    A DB2 user must be created before a schema with the same name can be created.

    C

    If no schema is specified when an object is created, the default schema PUBLIC is used.

    D

    A schema enables the creation of multiple objects in a database without encountering namespace collisions.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）
    A

    Table

    B

    Columns

    C

    Table and Alias

    D

    Columns and Alias


    正确答案： B
    解析： 暂无解析

相关内容