单选题Which of the following describes the objects of a DB2 database and their relationships?（）AInstanceBTable spaceCSystem catalogDSchema 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
参考解析
解析：
暂无解析
相关考题：
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
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
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.
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
Which of the following describes the objects of a DB2 database and their relationships?() A.InstanceB.Table spaceC.System catalogD.Schema repository
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.thingsB.objectsC.conditionsD.constrains
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.dataB.thingsC.entitiesD.objects
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/OSB、DB2 Runtime ClientC、DB2 Connect Enterprise EditionD、DB2 for i5/OS SQL Development Kit
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
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.
Which of the following describes the objects of a DB2 database and their relationships?（）A、InstanceB、Table spaceC、System catalogD、Schema repository
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
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.
You issued the following statement in your SQL*Plus session： SQLALTER 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 tablespaceB、 executing a long query that involves a sort operation and the statement runs out of temporary spaceC、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
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
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;
单选题Which of the following describes the objects of a DB2 database and their relationships?（）AInstanceBTable spaceCSystem catalogDSchema repository
单选题Which of the following database objects is considered executable using SQL?（）AViewBTableCRoutineDPackage
单选题A trigger can be created on which of the following objects?（）AViewBCatalog TableCStored ProcedureDGlobal Temporary Table
单选题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?（）AThe value for MINEXTENTS setting BThe value for PCTINCREASE setting CThe value for MAXEXTENTS setting DBy default, Oracle allocates six extents to all database objects
单选题Which of the following describes how DB2 9 stores an XML document if the XML Extender is not used?（）ACLOBBBLOBCHierarchicallyDRows and columns
单选题Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）AViewBAliasCTableDPackage
单选题Which describes the default behavior when you create a table? （）AThe table is accessible to all users.BTables are created in the public schema.CTables are created in your schema.DTables are created in the DBA schema.EYou must specify the schema when the table is created.
单选题Which of the following is a characteristic of a schema?（）AForeign key references cannot cross schema boundaries.BA DB2 user must be created before a schema with the same name can be created.CIf no schema is specified when an object is created, the default schema PUBLIC is used.DA schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题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？（）AALTER TABLE Service.Table SWITCH TO Costs.Table1; BALTER SCHEMA CostsTRANSFER Service.Table; CALTER USER Service WITH DEFAULT_SCHEMA = Costs; DALTER AUTHORIZATION ON Service.Table1 TO Costs;
单选题You issued the following statement in your SQL*Plus session： SQLALTER 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 tablespaceB executing a long query that involves a sort operation and the statement runs out of temporary spaceC loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitD creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
单选题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?（）ATableBColumnsCTable and AliasDColumns and Alias
单选题Which of the following database objects can be used to raise an error if a table is updated?（）APackageBTriggerCStored ProcedureDInformational Constraint