itgle.com

单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository

题目
单选题
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

相似考题

1.Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification

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.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

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
解析： 暂无解析
更多“单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository”相关问题

  • 第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题：

    The entity-relationship（E-R）data model is based on a perception of a real world that consists of a clletion of basic objects,called（请作答此空），and of relationships among these objects.An entity is a“thing”or"object"in the real world that is distinguishable from other objects.Entities are described in a database by asetof（ ）:A relationship isan association among several entities.The set of all entities of the same type and the set of all relationships of the ametype are termed an entity sct and relationship set,respectively.The overall logical structure（schema）of a database can be expressed graphically by an E-R diagram,which is built up from the fllowing components:（ ）represent entity set,（ ）represent atributes,ete.In addition to entities and relations,the E-R model represents certain（ ）to which thecontents of a database must conform.The entity-relationship model is widely used in database design.

    A.data
    B.things
    C.entities
    D.objects

    答案：C
    解析：

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Which describes the default behavior when you create a table?（）

    • A、The table is accessible to all users.
    • B、Tables are created in the public schema.
    • C、Tables are created in your schema.
    • D、Tables are created in the DBA schema.
    • E、You must specify the schema when the table is created.

    正确答案:C

  • 第6题：

    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

    • A、The value for MINEXTENTS setting 
    • B、The value for PCTINCREASE setting 
    • C、The value for MAXEXTENTS setting 
    • D、By default, Oracle allocates six extents to all database objects

    正确答案:A

  • 第7题：

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

  • 第8题：

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

    View

    B

    Catalog Table

    C

    Stored Procedure

    D

    Global Temporary Table


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

  • 第9题：

    单选题
    Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）
    A

    CLOB

    B

    BLOB

    C

    Hierarchically

    D

    Rows and columns


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

  • 第10题：

    单选题
    Which describes the default behavior when you create a table? （）
    A

    The table is accessible to all users.

    B

    Tables are created in the public schema.

    C

    Tables are created in your schema.

    D

    Tables are created in the DBA schema.

    E

    You must specify the schema when the table is created.


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

  • 第11题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）
    A

    ALTER TABLE Service.Table SWITCH TO Costs.Table1; 

    B

    ALTER SCHEMA CostsTRANSFER Service.Table; 

    C

    ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 

    D

    ALTER AUTHORIZATION ON Service.Table1 TO Costs;


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

  • 第12题：

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

  • 第13题：

    The entity-relationship（E-R）data model is based on a perception of a real world that consists of a clletion of basic objects,called（ ），and of relationships among these objects.An entity is a“thing”or"object"in the real world that is distinguishable from other objects.Entities are described in a database by asetof（ ）:A relationship isan association among several entities.The set of all entities of the same type and the set of all relationships of the ametype are termed an entity sct and relationship set,respectively.The overall logical structure（schema）of a database can be expressed graphically by an E-R diagram,which is built up from the fllowing components:（ ）represent entity set,（ ）represent atributes,ete.In addition to entities and relations,the E-R model represents certain（请作答此空）to which thecontents of a database must conform.The entity-relationship model is widely used in database design.

    A.things
    B.objects
    C.conditions
    D.constrains

    答案：D
    解析：

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

    • A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
    • B、 executing a long query that involves a sort operation and the statement runs out of temporary space
    • C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
    • D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

    正确答案:D

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs. In the options below， which Transact-SQL statement should you execute？（）

    • A、ALTER TABLE Service.Table SWITCH TO Costs.Table1; 
    • B、ALTER SCHEMA CostsTRANSFER Service.Table; 
    • C、ALTER USER Service WITH DEFAULT_SCHEMA = Costs; 
    • D、ALTER AUTHORIZATION ON Service.Table1 TO Costs;

    正确答案:B

  • 第19题：

    单选题
    Which of the following database objects is considered executable using SQL?（）
    A

    View

    B

    Table

    C

    Routine

    D

    Package


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

  • 第20题：

    单选题
    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）
    A

    The value for MINEXTENTS setting 

    B

    The value for PCTINCREASE setting 

    C

    The value for MAXEXTENTS setting 

    D

    By default, Oracle allocates six extents to all database objects


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

  • 第21题：

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

  • 第22题：

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

  • 第23题：

    单选题
    You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
    A

     creating a table in your schema and you exceed your allocated space quota on the tablespace

    B

     executing a long query that involves a sort operation and the statement runs out of temporary space

    C

     loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

    D

     creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error


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

  • 第24题：

    单选题
    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


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

相关内容