IBM IBM Certified Advanced Database Administrator A2090-544 Questions & Answers

• Question 81:

  Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

  A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

  B. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS

  C. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS

  D. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS

  Correct Answer: A

• Question 82:

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

  A. GET CURRENT ACTIVE LOGFILE

  B. LIST LOGFILES

  C. GET DATABASE CONFIGURATION

  D. LIST INDOUBT TRANSACTIONS

  Correct Answer: C

• Question 83:

  Which conditions must be met to implement HADR?

  A. 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. 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).

  C. 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).

  D. 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).

  Correct Answer: D

• Question 84:

  Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?

  A. Set ALTERNATER SERVER to fixed IP Addresses on both servers.

  B. Use a virtual IP Address for both servers.

  C. Use a virtual IP Address in the CATALOG DATABASE command.

  D. Catalog both servers separately and use a fixed IP address for both servers.

  Correct Answer: C

• Question 85:

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

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

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

  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.

  Correct Answer: C

• Question 86:

  When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?

  A. It terminates immediately.

  B. It remains active as long as the MAXAGENTS setting is not exceeded.

  C. It is placed in the agent pool if the connection is terminated.

  D. It automatically releases the database connection and returns to the pool.

  Correct Answer: C

• Question 87:

  If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

  A. DB2_APM_PERFORMANCE

  B. DB2_EXTENDED_IO_FEATURES

  C. DB2_RESOURCE_POLICY

  D. DB2_PARALLEL_IO

  Correct Answer: D

• Question 88:

  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 and C3 together, which statement(s) will create index(es) that will provide

  optimal query performance?

  A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1);CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3);

  B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3);

  C. CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1);

  D. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3);

  Correct Answer: B

• Question 89:

  Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)

  A. INTRA_PARALLEL NO

  B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100

  C. MAX_AGENTS 100, MAX_CONNECTIONS 2000

  D. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000

  E. INTRA_PARALLEL YES

  Correct Answer: BE

• Question 90:

  Which database manager configuration parameter is used to set an instance-wide soft limit on the total amount of memory that can be consumed by private sorts, within that instance, at any given time?

  A. SORTHEAP

  B. SHEAPTHRES_SHR

  C. SHEAPTHRES

  D. SORTHEAP_SHR

  Correct Answer: C