A2090-544 by IBM Actual Free Exam Questions And Answers

Question 1

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

A. It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.

B. It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.

C. It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.

D. It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.

Discussion 0

Correct Answer: D Vote an answer

Question 2

A DBA wants to migrate a DB2 LUW 8.2.2 database to version 9.7 and plans to use currently committed (CC) semantics on an application-by-application basis. Which process will yield the desired results?

A. Set the DB2_USE_CC_SEMANTICS registry variable to APPLICATION, then migrate the database.

B. Migrate the database, then assign the value AVAILABLE to the CURR_COMMIT configuration parameter.

C. Migrate the database, then assign the value ON to the CURR_COMMIT configuration parameter.

D. Set the DB2_USE_CC_SEMANTICS registry variable to YES, then migrate the database.

Discussion 0

Correct Answer: B Vote an answer

Question 3

If your DB2 server is not responding (hung), and you cannot run DB2 commands from the Command Line Processor, which utility can be used to list the applications currently connected to the database MYDB?

A. db2dart

B. db2apptrk

C. db2acsutil

D. db2pd

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which statement is true about clustering indexes in a partitioned database?

A. The clustering index column(s) should be suffixed by the partitioning key column(s).

B. The partitioning key column(s) should be added to the clustering index with the INCLUDE option.

C. The clustering index column(s) should be prefixed by the partitioning key column(s).

D. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.

Discussion 0

Correct Answer: C Vote an answer

Question 5

An active partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
1 server1 0
2 server1 1
3 server1 2
4 server1 3
The following command is issued to add a new database partition:
db2start DBPARTITIONNUM 5 ADD DBPARTITIONNUM HOSTNAME server1 PORT 4
Upon successful completion of the db2start command, which statement is true regarding the status of the instance DB2INST1?

A. All partitions are active but partition 5 is not available until a temporary table space is defined.

B. Partitions 1, 2, 3, and 4 are active, but partition 5 is not.

C. DB2 responds to the configuration change by stopping all partitions.

D. Partitions 1, 2, 3, 4, and 5 are active and available.

Discussion 0

Correct Answer: B Vote an answer

Question 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 the database?

A. ALTER DATABASE mydb AUTOMATIC STORAGE YES 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 ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;

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

Discussion 0

Correct Answer: B Vote an answer

Question 7

A database named DB1 has a database partition group named MULTIPG that has been defined
across partitions 3, 4 and 5.
The DBA issues the following series of commands/SQL statements:
CONNECT TO db1;
SET CURRENT DBPARTITIONNUM 4;
ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6);
Which partition will DB2 use as a model for table spaces on partition 6?

A. catalog partition

B. partition 5

C. partition 4

D. partition 3

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which action can be performed by the ALTER TABLESPACE statement?

A. Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.

B. Change an SMS table space to a DMS table space on any database partition.

C. Change the size of a container in an SMS table space.

D. Add a container to an SMS table space on a database partition that currently has no containers.

Discussion 0

Correct Answer: D Vote an answer

Question 9

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.

D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

Discussion 0

Correct Answer: B Vote an answer

Question 10

Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server?
TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY

A. Any time after 11:07:04 am

B. Any time after 11:02:03 am

C. Any time after 11:07:03 am

D. Any time before 11:07:03 am

Discussion 0

Correct Answer: D Vote an answer

IBM Assessment: DB2 9.7 Advanced DBA for LUW - A2090-544 Exam Practice Test

Contact Us

Useful Links

Latest Updated