IBM DB2 9.7 Advanced DBA for LUW Sample Questions:

1. Given the following statement: Which statement will successfully add a new partition to table T1 for April 2010?

A) Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.
B) Create a table with the same definition as the partitioned table; attach to the main partitioned table; data will be automatically redistributed across all table partitions.
C) Export data from the main partitioned table; create a table with the same definition as the partitioned table; attach to the main partitioned table; import data into the main partitioned table; run the SET INTEGRITY statement.
D) Export data from the main partitioned table; drop the main partitioned table; create the main partitioned table with new partitioning range; import data into the main partitioned table.

2. Given the following table definition in a multi-partitioned database:

Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?

A) EMP_ID
B) SS_ID
C) NAME
D) SS_ID, EMP_ID, and NAME

3. A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?

A) Perform the equivalent of RUNSTATS on ORA1 in Oracle.
B) Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.
C) Perform RUNSTATS on the ORA1 nickname at the federated server.
D) Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.

4. Which statement about compression and temporary tables is NOT correct?

A) When executing queries that require temporary tables, DB2 considers the storage savings and the impact to query performance to determine whether compression is worthwhile.
B) The minimum size that a table must be before compression is used is larger for temporary tables than for regular tables.
C) Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE ?COMPRESS YES statement.
D) The explain facility and the db2pd utility can be used to determine whether a temporary table has been compressed.

5. While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000;
CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node.
The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?

A) Add an entry into the Database Connection Services directory on the Windows client.
B) Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
C) Change the service name (SVCENAME) in the remote servers database configuration.
D) Add a Database Connection Services entry to the /etc/services file on the Windows client.

Solutions: