A2090-544問題集、IBM実際の試験問題

質問 1

A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?

A. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.

B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.

C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.

D. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.

正解: D

質問 2

Assuming table TAB_A resides in a DB2 9.7 database, what is one way to obtain an estimate of how much space could be saved if this table were compressed?

A. The ADMINGETTABCOMPRESSINFO_V97 table function.

B. The ADMINGETTABCOMPRESSINFO table function.

C. The ADMIN_GET_TAB_INFO table function.

D. The ADMIN_GET_TAB_COMPRESS_INFO_V97 table function.

正解: D

質問 3

What is the minimum authority required to execute the LOAD command?

A. ACCESSCTRL

B. SQLADM

C. SYSCTRL

D. DATAACCESS

正解: D

質問 4

A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?

A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?

D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

正解: B

質問 5

Which conditions must be met to implement HADR?

A. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

B. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

C. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).

D. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).

正解: B

質問 6

A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?

A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?

D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

正解: A

質問 7

If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?

A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'

B. ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')

C. ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')

D. ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')

正解: A

質問 8

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

A. Partition Assistant

B. Workload Manager

C. Design Advisor

D. Configuration Advisor

正解: C

質問 9

Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information: DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?

A. DB2_PARALLEL_IO=7:7

B. DB2_PARALLEL_IO=7:32

C. DB2_PARALLEL_IO=7:64

D. DB2_PARALLEL_IO=7:16

正解: A

質問 10

If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?

A. All sorts will be done in a temporary table space.

B. No shared memory is allocated for sorting.

C. The shared sort memory allocation will be controlled by DB2.

D. All sorts will be done in shared memory.

正解: C

IBM Assessment: DB2 9.7 Advanced DBA for LUW - A2090-544 模擬練習