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

1. Which two can be replicated using HADR? (Choose two.)

A) database configuration changes
B) Data Definition Language (DDL) statements
C) LOAD operations
D) CREATE TABLE... NOT LOGGED INITIALLY operations

2. When are packages automatically rebound?

A) When invalid packages are executed.
B) When the DB2_AUTO_REBIND registry variable is set to YES.
C) When inoperative packages are executed.
D) When the DB2_AUTO_REBIND configuration parameter is set to ENABLED

3. Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format.
Which command(s) can be used to do this?

A) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b
B) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b
C) EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b;
D) EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b

4. Click the Exhibit button.

What does the SQL in the exhibit show?

A) The SQL shows the most frequently used indexes on the SYSIBM.SYSINDEXES table since the last database activation
B) THE SQL shows indexes on SYSIBM.SYSINDEXES table that have not been used since the last database activation.
C) The SQL shows the most frequently used indexes on the SYSIBM.SYSTABLES table since the last database activation.
D) The SQL shows indexes on the SYSIBM.SYSTABLES table that are used for index-only access.

5. Click the Exhibit button.

Refer to the exhibit for information on how tables TABA and TABB were created. What would be the number of extents allocated for each table after the successful creation of both tables?

A) TABA: 1 extent TABB: 10 extents
B) TABA: 2 extents TABB: 20 extents
C) TABA: 4 extents TABB: 40 extents
D) TABA: 1 extent TABB: 1 extent

質問と回答：