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

• Question 1:

  A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

  A. Uncatalog and re-catalog the directory entries for the zOS database and try again.

  B. Catalog the zOS database in the Local Database Directory.

  C. Catalog the zOS database in the Database Connection Services Directory.

  D. Catalog the zOS database in the Distributed Data Facility Directory.

  Correct Answer: C

• Question 2:

  Which series of items are required to establish a TCP/IP connection to a DB2 for z/OS database from a DB2 for Linux, UNIX, or Windows server?

  A. hostname, logical unit (LU) name, target database name, local database name, node name

  B. hostname, logical unit (LU) name, subsystem ID, local database name, node name

  C. hostname, port number/protocol, subsystem ID, local database name, node name

  D. hostname, port number/protocol, target database name, local database name, node name

  Correct Answer: D

• Question 3:

  Click the Exhibit button.

  

  In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node. Explanation: The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

  A. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS

  B. CATALOG DCS DATABASE dsample AS db2t

  C. CATALOG DCS DATABASE db2t AS dsample

  D. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS

  Correct Answer: B

• Question 4:

  Given the following statement:

  

  Which statement will successfully add a new partition to table T1 for April 2010?

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

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

  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.

  Correct Answer: C

• Question 5:

  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 (year) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year, day))

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

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

  D. CREATE TABLE tab1(yearday INT,year CHAR(2),day INT))PARTITION BY RANGE (yearday) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (day))

  Correct Answer: C

• Question 6:

  Which option of the REORG TABLE statement will release blocks that contain no rows from a multidimensional clustering (MDC) table?

  A. RECLAIM EXTENTS ONLY

  B. RELEASE FREE EXTENTS ONLY

  C. RECLAIM FREE BLOCKS

  D. RELEASE FREE BLOCKS ONLY

  Correct Answer: A

• Question 7:

  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?

  A. Configuration Advisor

  B. Partition Assistant

  C. Design Advisor

  D. Workload Manager

  Correct Answer: C

• Question 8:

  How can you change an existing non-partitioned index for a partitioned table to a partitioned index?

  A. Use the ALTER INDEX command.

  B. Use the DROP INDEX and CREATE INDEX commands.

  C. Use the REORG INDEX command.

  D. Use the ALTER INDEX and REORG INDEX commands.

  Correct Answer: B

• Question 9:

  A database named DB1 has a database partition group named MULTIPG that has been defined across

  partitions 3, 4 and 5.

  The DBA issues the following series of commands/SQL statements:

  CONNECT TO db1;

  SET CURRENT DBPARTITIONNUM 4;

  ALTER DATABASE PARTITION GROUP multigp ADD DBPARTITIONNUM (6); Which partition will DB2

  use as a model for table spaces on partition 6?

  A. catalog partition

  B. partition 3

  C. partition 4

  D. partition 5

  Correct Answer: B

• Question 10:

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

  B. EMP_ID

  C. NAME

  D. SS_ID, EMP_ID, and NAME

  Correct Answer: A