Which one of the following statements is true?
A. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence).
B. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence).
C. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.
D. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.}
正解:C
質問 2:
What is the purpose of the XQuery builder tool included in DB2?
A. The XQuery builder tool does not exist in DB2.
B. The XQuery builder tool allows you to create queries against XML data.
C. The XQuery builder tool builds well-formed XML documents that can be stored in a hierarchicalform within columns of a table.
D. The XQuery builder tool allows you to query and retrieve data from external XML documents.
正解:B
質問 3:
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 asit 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
質問 4:
What are DB2 constraints?
A. DB2 constraints are rules that can be imposed on data values (in a table) so that they conformto a certain property or business rule.
B. A DB2 constraint restricts the tables that can be related together due to database size issues.
C. DB2 constraints are the limits of the database installation when you install and set up your DB2database.
D. A DB2 constraint is a limitation in the DB2 Express product designed to make it less powerfulthan the full DB2 product.
正解:A
質問 5:
How can you verify that a DB2 installation was successful?
A. Verification is automatically performed by the AUTO_CONFIGURE feature.
B. Verification is completed by the DBA using the database verification toolkit.
C. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.
D. Verification is performed by running the VERIFY INSTALL command.
正解:C
質問 6:
How is DB2 installed on the server?
A. DB2 can be installed using the DB2 installation wizard.
B. DB2 must be installed on RAM drive on the server to speed up performance of the database.
C. DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.
D. DB2 can only be installed from a command prompt using command-line entries.
正解:A
Kurosaka -
いちばんやさしいC2090-548で学習してからがちょうどくらいだと思います。知識は勉強してからチャレンジもあります