Prepare with reliable A2090-544 Pass-King Test Braindumps

IBM A2090-544 Exam Overview:

IBM A2090-544 Exam Syllabus Topics:

IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:

1. Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2, C3 and C4 together, which statement(s) will create index(es) that will provide optimal query performance?

A) CREATE UNIQUE INDEX xtab1 ON tab1 (c3) INCLUDE (c1, c2, c4);
B) CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3, c4);
C) CREATE UNIQUE INDEX xtab1 ON tab1 (c4, c3, c2, c1);
D) CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3, c4);

2. 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) DB2 responds to the configuration change by stopping all partitions.
B) Partitions 1, 2, 3, and 4 are active, but partition 5 is not.
C) Partitions 1, 2, 3, 4, and 5 are active and available.
D) All partitions are active but partition 5 is not available until a temporary table space is defined.

3. 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 with the CREATE INDEX statement that is used to create it.
B) 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.
C) 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.
D) 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.

4. 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:32
B) DB2_PARALLEL_IO=7:7
C) DB2_PARALLEL_IO=7:16
D) DB2_PARALLEL_IO=7:64

5. Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A) GET DATABASE CONFIGURATION
B) GET CURRENT ACTIVE LOGFILE
C) LIST LOGFILES
D) LIST INDOUBT TRANSACTIONS

Solutions: