违法和不良信息举报 联系客服
免费注册 登录

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

第2题：

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

第3题：

Which of the following is not responsibility of DBA(Data Base Administrator)?

A．Database management system design

B．Database schema definition

C．Database schema modification

D．Integrity constraint specification


正确答案：A

第4题：

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

第5题：

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
解析：

第6题：

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

第7题：

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
解析：

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容