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

更多“单选题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 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

点击查看答案
第2题

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

点击查看答案
第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题

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

点击查看答案
第5题

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

点击查看答案
第6题

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.

点击查看答案
第7题

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

点击查看答案

单选题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 InstanceB Table spaceC System catalogD Schema repository”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容