IBM DB2 9.7 DBA for Linux UNIX and Windows 認定 C2090-541 試験問題:

1. Which two operations allow you to control the creation of the compression dictionary using the KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)

A) IMPORT
B) TRUNCATE
C) REORG
D) LOAD

2. Click the Exhibit button.

Refer to the logging configuration parameters shown in the exhibit.
If the active log path was only configured to have enough space for 100 active log files, what will happen if there are currently 100 active log files and DB2 needs to create active log file 101?

A) The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log space and active log path are both full. The transaction will be rolled back andit's associated application will be forced off.
B) The database will continue normal operation because infinite logging has been enabled and any logs that will not fit in the active log path will automatically be created within the OVERFLOWLOGPATH until logs in the active log path begin to be archived.
C) The database will appear to be hung because the BLK_LOG_DSK_FUL configuration parameter is set to YES. Once some active log files arearchived,the database will resume normal operation.
D) The transaction that prompts DB2 to try and create log file 101 will receive a "log full" error because the active log path is full. The transaction will be rolled back andit's associated application will be forced off.

3. For which two events is it recommended to execute RUNSTATS? (Choose two.)

A) When a table is created.
B) When LOAD with STATISTICS has been run.
C) When row compression has been enabled.
D) When a table is altered by adding new columns.

4. Which set of procedures will be required to perform a rolling upgrade in a HADR environment?

A) 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
B) 1. Upgrade the system where the standby database resides.
2.Issue the TAKEOVER HADR command on the standby database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
C) 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the original primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.
D) 1. Upgrade the system where the primary database resides.
2.Issue the TAKEOVER HADR command on the primary database server.
3.Upgrade the new primary database.
4.Return to the original configuration by switching the roles of the primary and standby databases.

5. Which two data types can be in-lined to enhance compression? (Choose two.)

A) LONG VARCHAR
B) LOB
C) XML
D) GRAPHIC

質問と回答：