714 お客様のコメント
質問 1：
What does the SQL SELECT statement do?
A. The SQL SELECT statement allows the DBA to create table structures and pre-populate thosetable structures with database metadata.
B. The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.
C. The SQL SELECT statement is used to return rows of data from your database table or tables.
D. The SQL SELECT statement is used to return the status of the health of the database in thehealth DB2 health center application.
正解：C
質問 2：
Which utility must be used to recreate the primary index for a PHIDAM database?
A. HISAM Reload
B. Index/ILDS Rebuild
C. Recovery
D. Prefix Resolution
正解：B
質問 3：
What is the DB2 design advisor?
A. The DB2 design advisor is a help desk facility that is available to all licensed DB2 owners thathave paid their maintenance agreements with IBM. The tool is a Web site that guides youthrough the design of your database, with the DBA responding to a series of questions. Itproduces a database schema that allows for quick database creation.
B. The DB2 design advisor is a tool that automatically analyzes your running database andcontinuously makes changes to your database, so that the database is running at peakperformance.
C. The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, and then recommends performance changes to your database.
D. DB2 has no design advisor tool.
正解：C
質問 4：
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
質問 5：
Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A. Temporal tables provide a quick and easy way to track and record data changes in the table.
B. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
C. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
D. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
正解：B
質問 6：
If the user specifies multiple PCBs for a single database in a PSBGEN, which statement is correct?
A. It allows for multiple positions.
B. Only one of them can be used.
C. It is illegal.
D. The processing options must be identical.
正解：A
What does the SQL SELECT statement do?
A. The SQL SELECT statement allows the DBA to create table structures and pre-populate thosetable structures with database metadata.
B. The SQL SELECT statement is not used in DB2 because DB2 is a hierarchical database.
C. The SQL SELECT statement is used to return rows of data from your database table or tables.
D. The SQL SELECT statement is used to return the status of the health of the database in thehealth DB2 health center application.
正解：C
質問 2：
Which utility must be used to recreate the primary index for a PHIDAM database?
A. HISAM Reload
B. Index/ILDS Rebuild
C. Recovery
D. Prefix Resolution
正解：B
質問 3：
What is the DB2 design advisor?
A. The DB2 design advisor is a help desk facility that is available to all licensed DB2 owners thathave paid their maintenance agreements with IBM. The tool is a Web site that guides youthrough the design of your database, with the DBA responding to a series of questions. Itproduces a database schema that allows for quick database creation.
B. The DB2 design advisor is a tool that automatically analyzes your running database andcontinuously makes changes to your database, so that the database is running at peakperformance.
C. The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, and then recommends performance changes to your database.
D. DB2 has no design advisor tool.
正解：C
質問 4：
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
質問 5：
Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A. Temporal tables provide a quick and easy way to track and record data changes in the table.
B. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
C. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
D. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
正解：B
質問 6：
If the user specifies multiple PCBs for a single database in a PSBGEN, which statement is correct?
A. It allows for multiple positions.
B. Only one of them can be used.
C. It is illegal.
D. The processing options must be identical.
正解：A
织田** -
ソフトC2090-548問題集は明確に機能し、間違った答えをすべて覚えやすくなっています。