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

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

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

3. What information is NOT included as part of a DB PCB returned to an application program?

A) Segment Name
B) Segment Length
C) Database Name
D) Status Code

4. Which one of the following options is NOT a new feature introduced in DB2 10?

A) INGEST utility
B) Multi-Temperature Data Management
C) Table Partitioning
D) Temporal Tables

5. DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for
both partial and complete site failures. Given the sentences below, select the CORRECT statement about
HADR.

A) HADR protects against data loss by replicating data changes from a source database, called the
primary, to a target database, called the standby.
B) HADR feature is only available for DB2 Advanced Enterprise Edition.
C) HADR protects against data loss by replicating data changes from a backup database file to a standby
database.
D) HADR protects against data loss by saving data changes from a source database into a local recovery
log file.

質問と回答：