IBM Certified Database Administrator - IBM IMS 認定 C9050-548 試験問題:

1. What is the purpose of the TRANSFER OWNERSHIP SQL statement in DB2?

A) This statement allows for another DB2 table to wn the data that exists in a column in anothertable.
B) This statement allows you to transfer DB2 licenses to another company.
C) This statement provides the capability to change the ownership of a database object.
D) This statement does not exist in DB2.

2. Which of the following options best describes the differences between Label Based Access Control
(LBAC) and Row and Column Access Control (RCAC)?

A) RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on
who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and
Column Access Control rules.
B) RCAC is a fixed label security model designed for the US government while LBAC is a general purpose
security model best suited for commercial customers.
C) With RCAC users do not get an error when accessing protected data, while with LBAC users can get
an error if they don't have the necessary credentials to access a LBAC protected column.
D) LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and
columns.

3. What is the role of the DB2 control center?

A) The DB2 control center is the main table where all metadata about the database is stored in aDB2
database.
B) The DB2 control center serves as a collection of command-line entry commands that allow theDBA to
administer the DB2 database.
C) DB2 does not have a DB2 control center.
D) The DB2 control center allows you to administer all your systems, instances, databases, anddatabase
objects.

4. When the database has been installed on your server, you should verify that the installation has
completed successfully. How do you verify the installation?

A) Verification of a database installation is done by successfully accessing data from the SAMPLE
database.
B) Verification of a database installation is automatically performed by the installation program after
installation.
C) Verification of a database installation is completed by the DBA using the toolkit database verification
application.
D) Verification of the database is performed by running the VERIFY INSTALL SQL command.

5. Which one of the following statements is FALSE about DB2 Workload Management (WLM)?

A) When a WLM threshold condition is violated an action is executed in order to maintain stability in the
system.
B) DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a
different service class.
C) DB2 Workload Management dispatcher can be used to control sharing of memory resources among
active workloads.
D) DB2 Workload Management uses workloads to identify incoming work based on the connection
attributes under which the work is submitted.

質問と回答：