We're so confident of our products that we provide no hassle product exchange.
IBM Assessment: DB2 9.7 Advanced DBA for LUW Sample Questions:
1. If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?
A) The shared sort memory allocation will be controlled by DB2.
B) No shared memory is allocated for sorting.
C) All sorts will be done in shared memory.
D) All sorts will be done in a temporary table space.
2. The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This table needs to be partitioned by column YEARDAY with three months per data partition. Additionally, data needs to be organized 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?
A) CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (day))
B) CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
C) CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year, day))
D) CREATE TABLE tab1
(yearday INT,
year CHAR(2),
day INT))
PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)
ORGANIZE BY DIMENSIONS (year))
3. 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.
4. What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?
A) Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a RESTORE DATABASE command with the CONTINUE option;
B) Issue a RESTORE DATABASE command with the REDIRECT option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option;
C) Issue a RESTORE DATABASE command with the ROLLFORWARD option;
issue a SET TABLESPACE CONTAINERS command;
issue a RESTORE DATABASE command with the CONTINUE option;
D) Issue a RESTORE DATABASE command with the REDIRECT option;
issue a RESTORE DATABASE command with the CONTINUE option;
5. Which command would be used to obtain the name of the first active log file for a database with log retain enabled?
A) LIST LOGFILES
B) GET DATABASE CONFIGURATION
C) GET CURRENT ACTIVE LOGFILE
D) LIST INDOUBT TRANSACTIONS
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: D | Question # 3 Answer: D | Question # 4 Answer: B | Question # 5 Answer: B |
By Malcolm
