Which statements will enable automatic storage in storage group SG_HOT for a given database managed table spac
Which statements will enable automatic storage in storage group SG_HOT for a given
database managed table space MY_TS and remove all existing non-automatic storage
containers from the table space?
Which statement about range-clustered tables is true?
Which statement about range-clustered tables is true?
Which tool can be used to mimic statistics for tables by gathering statistics from a production database and p
Which tool can be used to mimic statistics for tables by gathering statistics from a
production database and placing them into a test database?
What can you use to move data from an existing DMS table space to an automatic storage table space, while the
You have just converted an existing database to an automatic storage database. What can
you use to move data from an existing DMS table space to an automatic storage table
space, while the data remains online and available for access?
Which statement will execute successfully?
If an MQT named Q1_SALES was created as follows: Which statement will execute
successfully?
Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compress
Table TAB1 was created as follows: Which statement(s) should be used to create an index
on column COL1 of table TAB1 that is enabled for compression?
Which statement about the ADMIN_MOVE_TABLE procedure is true?
Which statement about the ADMIN_MOVE_TABLE procedure is true?
Which statement about Binary XML is FALSE?
Which statement about Binary XML is FALSE?
Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and
Which XML format provides a faster way to transmit and receive XML data between Java
pureXML applications and a DB2 server?
which statement is true?
Given a system-period temporal table POLICY_INFO with its associated history table
HIST_POLICY_INFO, which statement is true?