What can you use to move data from an existing DMS tabl…
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 tool can be used to mimic statistics for tables b…
Which tool can be used to mimic statistics for tables by gathering statistics from a production database and
placing them into a test database?
Which statement about range-clustered tables is true?
Which statement about range-clustered tables is true?
Which statements will enable automatic storage in stora…
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?
What indexes will be created for table TAB1?
If the following statement is executed:
What indexes will be created for table TAB1?
Which statement describes adaptive row compression?
Which statement describes adaptive row compression?
Which statement is true?
If the following command is executed:
Which statement is true?
Which statement describes a way to minimize the impact …
Which statement describes a way to minimize the impact of a RUNSTATS operation?
What can be used to provide input to the Design Advisor?
What can be used to provide input to the Design Advisor?
Which statement about updating index statistics with th…
Which statement about updating index statistics with the RUNSTATS command is true?