IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 2

1.

The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (yearmonth)) CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (yearmonth)) CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (year)) CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))

2.

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?

Configuration Advisor Partition Assistant Design Advisor Workload Manager

3.

How can a DBA validate that an existing backup was compressed?

Check the output from the command LIST HISTORY BACKUP ALL FOR the database. Check the value of the COMPRESS_BACKUP database configuration setting. Check the value of the DB2_COMPRESS_BACKUP registry variable. Check the header information of the backup file using db2ckbkp.

4.

If LOGSECOND=-1 then which of the following statements is true?

You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on araw device. The database will reserve active log space for transactions that may need to roll back and write log records. An infinite number of overflow log files will be used with archival logging.

5.

Which conditions must be met to implement HADR?

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

6.

In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?

The HADR_TIMEOUT value must be identical on both the primary and the standby server. Changes to the HADR_TIMEOUT value will take effect immediately. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.

7.

The RECOVER command is used in an attempt to fix a damaged table space. What will the system do during the RECOVER process?

Create a new temporary table space if the damaged table space is a temporary table space. Restore the database and attempt to make as much of the database available as possible. Restore the database and bypass inaccessible containers and make the rest of the table space available. Prompt the user for new container definitions for damaged or missing containers.

8.

Which command CANNOT be used to create the compression dictionary for a table?

IMPORT INSPECT LOAD RUNSTATS

9.

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

Any time after 11:02:03 am Any time before 11:07:03 am Any time after 11:07:04 am Any time after 11:07:03 am

10.

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

GET CURRENT ACTIVE LOGFILE LIST LOGFILES GET DATABASE CONFIGURATION LIST INDOUBT TRANSACTIONS

IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Assessment DB2 9.7 Advanced DBA for LUW - Assessment Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner