What is DB2 Express-C?
A. DB2 Express-C is the command-line interface for the DB2 Express product.
B. DB2 Express-C is not an existing product.
C. DB2 Express-C is latest version of DB2 Express, which follows the former versions DB2Express-A and
DB2 Express-B.
D. DB2 Express-C is a no-charge data server version of the DB2 Express edition for thecommunity.
正解:D
質問 2:
Which one of the following options is CORRECT about Temporal Tables?
A. Temporal tables are complex to maintain and require major application changes.
B. Temporal tables are used to model data in the past and present. They cannot be used to model data in
the future.
C. Temporal tables require constant changes to the operating system timestamp in order to navigate
through time in the database.
D. Temporal tables are used to model data in the past, present, and future.
正解:D
質問 3:
What does the table partitioning feature in DB2 allow you to do?
A. Table partitioning allows you to create very large tables that are divided across multiple storage objects
so that you can quickly attach and detach large quantities of data from the tables.
B. Table partitioning allows you to partition the table data based on the hash values of the primary key.
C. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing
the performance of your DB2 database.
D. Table partitioning allows you to create result set tables from a join query, which automatically splits the
data into smaller chunks, thereby increasing the performance of your DB2 database.
正解:A
質問 4:
What is the role of the DB2 task center?
A. The task center does not exist in DB2.
B. The DB2 task center displays all tasks that were completed to create your DB2 database. It allows you
to make changes to the DB2 metadata only.
C. The DB2 task center is an automated feature in the DB2 product that monitors the heath of your DB2
database and executes tasks that maintain the health of your database. When they have been executed,
tasks are listed for your review.
D. The DB2 task center is used to run or schedule tasks and to notify people about the status of
completed tasks.
正解:D
質問 5:
What is a table space in DB2?
A. A table space is a DB2 component that manages access to databases.
B. A table space is a space reserved for catalog tables and base table data.
C. A table space is an area of main memory that has been allocated by the database manager for the
purpose of caching table and index data as it is read from the physical media.
D. A table space is a logical storage grouping that can be composed of one or more containers.
正解:D
保坂** -
読む側も得意な項目は省略したりなど
自分でペースを考えて勉強した方が効率的。C9050-548問題集に当たっても良いと思います。