单选题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?（）

Instance

Table space

System catalog

Schema repository

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

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

点击查看答案
第2题

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

点击查看答案
第3题

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

点击查看答案
第4题

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

点击查看答案
第5题

单选题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？（）Acreating a table in your schema and you exceed your allocated space quota on the tablespaceBexecuting a long query that involves a sort operation and the statement runs out of temporary spaceCloading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limitDcreating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

点击查看答案
第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 TableB ColumnsC Table and AliasD Columns and Alias

点击查看答案
第7题

单选题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 describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容