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 DB2 data types has a fixed length?()A.XMLB.BLOBC.DOUBLED.DBCLOB

2.A stored procedure object is created into which DB2 object?()A.AliasB.SchemaC.PackageD.Routine Space

3.Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?（）A、Visual ExplainB、Activity MonitorC、SQL Performance MonitorD、DB2 Performance Monitor

4.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 objec”相关问题

  • 第1题：

    Which ONE of the following statements about Domino Enterprise server is true？（）

    • A、Can host Active Server Pages Web sites
    • B、Can host PHP Web sites
    • C、Includes a DB2 server
    • D、Includes an integrated Web application server

    正确答案:D

  • 第2题：

    Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?（）

    • A、DB2 Express Edition
    • B、DB2 Personal Edition
    • C、DB2 Workgroup Server Edition
    • D、DB2 Enterprise Server Edition

    正确答案:C

  • 第3题：

    Which of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）

    • A、DB2 for i5/OS
    • B、DB2 Runtime Client
    • C、DB2 Connect Enterprise Edition
    • D、DB2 for i5/OS SQL Development Kit

    正确答案:A

  • 第4题：

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

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

    正确答案:B

  • 第5题：

    Which of the following are all valid DB2 data types?（）

    • A、LONG VARCHAR, SMALLINT, NUMBER, BLOB
    • B、DECIMAL, DATE, DBCLOB, INTERVAL
    • C、NUMERIC, TIMESTAMP, BYTE, FLOAT
    • D、NUM, TIME, XML, DOUBLE

    正确答案:D

  • 第6题：

    Which of the following DB2 data types has a fixed length?（）

    • A、XML
    • B、BLOB
    • C、DOUBLE
    • D、DBCLOB

    正确答案:C

  • 第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 of the following DB2 products are required on an iSeries or System i server to enable an application running on that server to retrieve data from a DB2 database on a Linux server?（）
    A

    DB2 for i5/OS

    B

    DB2 Runtime Client

    C

    DB2 Connect Enterprise Edition

    D

    DB2 for i5/OS SQL Development Kit


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

  • 第9题：

    单选题
    Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）
    A

    DB2 Express Edition

    B

    DB2 Personal Edition

    C

    DB2 Workgroup Server Edition

    D

    DB2 Enterprise Server Edition


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

  • 第10题：

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

    Sequence

    B

    Trigger

    C

    Schema

    D

    View


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

  • 第11题：

    单选题
    Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?（）
    A

    DB2 Express Edition

    B

    DB2 Personal Edition

    C

    DB2 Workgroup Server Edition

    D

    DB2 Enterprise Server Edition


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

  • 第12题：

    单选题
    Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）
    A

    DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

    B

    When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

    C

    When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.

    D

    When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.


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

  • 第13题：

    Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）

    • A、Control Center
    • B、Development Center
    • C、Developer Workbench
    • D、Stored Procedure Builder

    正确答案:C

  • 第14题：

    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）

    • A、create
    • B、import
    • C、load
    • D、sqlimport
    • E、update

    正确答案:B,D

  • 第15题：

    Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?（）

    • A、DB2 Express Edition
    • B、DB2 Personal Edition
    • C、DB2 Workgroup Server Edition
    • D、DB2 Enterprise Server Edition

    正确答案:D

  • 第16题：

    Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?（）

    • A、DB2 for z/OS
    • B、DB2 Run-Time Client for z/OS
    • C、DB2 Connect Enterprise Edition for z/OS
    • D、z/OS Application Connectivity to DB2 for z/OS and OS/390

    正确答案:A

  • 第17题：

    Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?（）

    • A、DB2 will no longer allow updating the value of IDCOL1 in TABLE1.
    • B、When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
    • C、When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.
    • D、When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.

    正确答案:B

  • 第18题：

    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

  • 第19题：

    Which of the following best describes how locks are used in DB2?（）

    • A、To maintain control of updated rows for commit processing
    • B、To ensure only committed changes are altered by another application
    • C、To allow two applications to update the same row of data simultaneously
    • D、To prevent multiple applications from accessing the same data simultaneously

    正确答案:B

  • 第20题：

    单选题
    Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?（）
    A

    Design Advisor

    B

    Visual Explain

    C

    Performance Advisor

    D

    Configuration Assistant


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

  • 第21题：

    单选题
    Which of the following best describes how locks are used in DB2?（）
    A

    To maintain control of updated rows for commit processing

    B

    To ensure only committed changes are altered by another application

    C

    To allow two applications to update the same row of data simultaneously

    D

    To prevent multiple applications from accessing the same data simultaneously


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

  • 第22题：

    单选题
    Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）
    A

    The next value will be 0 and the sequence will never use the values 101 to 105.

    B

    The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

    C

    Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

    D

    The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.


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

  • 第23题：

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


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

相关内容