A DBA wants to create a table named SALES that has the following characteristics:Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21.Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22.Which clause must be used with the CREATE TABLE statement to define this table?
Which Range-Clustered Tables (RCT) statement is correct?
A table named SALES was created as follows:Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of2013 to the SALES table and leave the table accessible?
In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
A DBA wants to create a table named SALES that has the following characteristics:Effective data clustering and management of space utilization.Rows in the table should be clustered based on when they are added to the table.Which clause must be used with the CREATE TABLE statement to define this table?
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
