Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with
the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF
format. Which command(s) can be used to do this?

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the
statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE

Which two operations allow you to control the creation of the compression dictionary using the
KEEPDICTIONARY/RESETDICTIONARY options? (Choose two.)

Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY,
lastname VARCHAR(50));
Which SQL statement will execute successfully?

Which two data types can be in-lined to enhance compression? ( Choose two.)

Given a table that is already compressed, if you create a new index on
that table, when will the index be compressed?

Refer to the Exhibit.

Refer to the exhibit for information on how tables TABA and TABB were created.
What would be the number of extents allocated for each table after the successful creation of both
tables?

Which two tools can create a compression dictionary? (Choose two.)

Which statement is true about using the EXPORT utility with a table that contains XML data?

When using table partitioning, which three operations are valid? (Choose three.)