单选题Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A ViewB AliasC TableD Package

题目
单选题
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）
A

View

B

Alias

C

Table

D

Package

相似考题

1.Which of the following objects can be directly referenced by a window object? ()A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer group

2.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.TableB.ColumnsC.Table and AliasD.Columns and Alias

3.Which of the following database objects is considered executable using SQL?()A.ViewB.TableC.RoutineD.Package

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

更多“单选题Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A ViewB AliasC TableD Package”相关问题

  • 第1题：

    Which of the following describes the objects of a DB2 database and their relationships?()

    A.Instance

    B.Table space

    C.System catalog

    D.Schema repository


    参考答案：C

  • 第2题：

    In which of the following situations should correlation names be used?()

    A.A table referenced in the FROM clause has no indexed column.

    B.The table referenced in the FROM clause has more than 200 columns.

    C.Two or more tables in the FROM clause have identical column names.

    D.The FROM clause contains two or more tables in the SELECT statement.


    参考答案：C

  • 第3题：

    Which of the following are types of routine objects?()

    A.Package and function

    B.Function and userexit

    C.Procedure and package

    D.Function and procedure


    参考答案：D

  • 第4题：

    A trigger can be created on which of the following objects?（）

    • A、View
    • B、Catalog Table
    • C、Stored Procedure
    • D、Global Temporary Table

    正确答案:A

  • 第5题：

    Which of the following provides a logical grouping of database objects?（）

    • A、View
    • B、Table
    • C、Schema
    • D、Buffer pool

    正确答案:C

  • 第6题：

    Which of the following database objects is considered executable using SQL?（）

    • A、View
    • B、Table
    • C、Routine
    • D、Package

    正确答案:C

  • 第7题：

    Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）

    • A、View
    • B、Alias
    • C、Table
    • D、Package

    正确答案:B

  • 第8题：

    Which of the following describes the objects of a DB2 database and their relationships?（）

    • A、Instance
    • B、Table space
    • C、System catalog
    • D、Schema repository

    正确答案:C

  • 第9题：

    Which of the following objects can be directly referenced by a window object？（）

    • A、 Schedule object
    • B、 Program object
    • C、 Job object
    • D、 Resource plan
    • E、 Resource consumer group

    正确答案:A,D

  • 第10题：

    单选题
    Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）
    A

    View

    B

    Alias

    C

    Table

    D

    Package


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

  • 第11题：

    多选题
    Which of the following statements are true when creating NETBIOS names？ （）
    A

    NETBIOS names can only use alphanumeric characters.

    B

    You can use a ’.’ in a NETBIOS name.

    C

    You can use an ’_’ （underscore） in a NETBIOS name.

    D

    NETBIOS names must be UPPERCASE

    E

    NETBIOS names can be a maximum of 32 characters


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

  • 第12题：

    单选题
    In which of the following situations should correlation names be used?（）
    A

    A table referenced in the FROM clause has no indexed column.

    B

    The table referenced in the FROM clause has more than 200 columns.

    C

    Two or more tables in the FROM clause have identical column names.

    D

    The FROM clause contains two or more tables in the SELECT statement.


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

  • 第13题：

    Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?()

    A.View

    B.Alias

    C.Table

    D.Package


    参考答案：B

  • 第14题：

    A trigger can be created on which of the following objects?()

    A.View

    B.Catalog Table

    C.Stored Procedure

    D.Global Temporary Table


    参考答案：A

  • 第15题：

    Which of the following provides a logical grouping of database objects?()

    A.View

    B.Table

    C.Schema

    D.Buffer pool


    参考答案：C

  • 第16题：

    In which of the following situations should correlation names be used?（）

    • A、A table referenced in the FROM clause has no indexed column.
    • B、The table referenced in the FROM clause has more than 200 columns.
    • C、Two or more tables in the FROM clause have identical column names.
    • D、The FROM clause contains two or more tables in the SELECT statement.

    正确答案:C

  • 第17题：

    Which of the following statements are true when creating NETBIOS names？ （）

    • A、 NETBIOS names can only use alphanumeric characters.
    • B、 You can use a ’.’ in a NETBIOS name.
    • C、 You can use an ’_’ （underscore） in a NETBIOS name.
    • D、 NETBIOS names must be UPPERCASE
    • E、 NETBIOS names can be a maximum of 32 characters

    正确答案:B,C

  • 第18题：

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

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

    正确答案:D

  • 第19题：

    Which of the following are types of routine objects?（）

    • A、Package and function
    • B、Function and userexit
    • C、Procedure and package
    • D、Function and procedure

    正确答案:D

  • 第20题：

    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

  • 第21题：

    单选题
    Which of the following describes the objects of a DB2 database and their relationships?（）
    A

    Instance

    B

    Table space

    C

    System catalog

    D

    Schema repository


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

  • 第22题：

    单选题
    On which of the following database objects may the SELECT privilege be controlled?（）
    A

    Sequence

    B

    Schema

    C

    Group

    D

    View


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

  • 第23题：

    多选题
    Which of the following objects can be directly referenced by a window object？（）
    A

    Schedule object

    B

    Program object

    C

    Job object

    D

    Resource plan

    E

    Resource consumer group


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

  • 第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
    解析： 暂无解析

相关内容