Online Access Free C2090-544 Practice Test

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; attach to the main partitioned table; data will be automatically redistributed across all table partitions.
• B.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.
• 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; 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.

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, subsystem ID, local database name, node name
• B.hostname, logical unit (LU) name, target database name, local database name, node name
• C.hostname, port number/protocol, target database name, local database name, node name
• D.hostname, port number/protocol, subsystem ID, local database name, node name

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

Which action can be performed by the ALTER TABLESPACE statement?

• A.Change an SMS table space to a DMS table space on any database partition.
• B.Add a container to an SMS table space on a database partition that currently has no containers.
• C.Change the size of a container in an SMS table space.
• D.Change the EXTENTSIZE setting for a table space on a database partition that currently has no containers.

Which statement about compression and temporary tables is NOT correct?

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