IBM C2090-548 問題集

質問 1：
What are DB2 wizards?
A. DB2 wizards are DBAs that are considered the top of their field in DB2.
B. DB2 wizards are programs that assist you in completing a single task by stepping you throughthe task.
C. DB2 wizards programs are automated in DB2. They run as background processes of thedatabase and they automatically configure database parameters.
D. DB2 does not have wizard functionality.
正解：B

質問 2：
What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A. The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
B. STMM allows DBAs to inspect the current memory allocation by buffer pools.
C. This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
D. This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
正解：D

質問 3：
Which of the following options best defines the Label-Based Access Control (LBAC) feature?
A. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.
B. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.
C. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.
D. DB2 LBAC monitors table data access and tables modifications made by database users.
正解：C

質問 4：
The following are true about the Configuration Advisor, EXCEPT:
A. By default, the Configuration Advisor is automatically executed when you create a new database.
B. It creates database objects such as indexes and MQTs to improve performance.
C. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
D. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
正解：B

質問 5：
What is the LOAD authority in DB2?
A. LOAD authority in DB2 is the main DBA in your organization that allows for a database to beloaded.
B. LOAD authority does not exist in DB2.
C. LOAD authority is at the database level. When combined with the INSERT privilege on a table,it allows the user to load data into that table.
D. LOAD authority is a permission granted to a database table that allows the table the accessesrights to load a backup database.
正解：C

質問 6：
What is the DB2 command editor?
A. The DB2command editor does not exist in DB2.
B. The DB2 command editor is a new feature in DB2. It is a command-line tool that allows you todefine and implement new SQL commands to be used in relational operations on thedatabase.
C. The DB2 command editor is the initial command-line interface that allows you to install theDB2 product.
D. The DB2 command editor is a tool that allows you to work with query results; view graphicalrepresentation of the access plan for SQL statements; run commands in sequence; andcreate, save, and schedule the execution of scripts.
正解：D

質問 7：
How is DB2 installed on the server?
A. DB2 can only be purchased pre-installed on an IBM server. There is no need to ever installDB2.
B. DB2 can be installed using the DB2 installation wizard.
C. DB2 must be installed on RAM drive on the server to speed up performance of the database.
D. DB2 can only be installed from a command prompt using command-line entries.
正解：B

質問 8：
Which one of the following options is CORRECT about Temporal Tables?
A. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
B. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
C. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
D. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
正解：B