Which feature introduced in DB2 9.7 allows faster roll-in and roll-out
of data partitions?

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?

What are two available forms of compression in DB2 9.7? (Choose two.)

You want to estimate the potential index compression savings for existing
indexes on a table
What do you use to obtain this information?

You have a new table created with COMPRESS YES and a delimited ASCII file.
You use the LOAD utility to load the data from the ASCII file into the table.
When will all of the rows in the table be compressed?

You are unable to configure a data source using DB2 Discovery.
What are three reasons why this is happening? (Choose three.)

You want to federate communication between two databases
What are two key requirements? (Choose two.)

Which driver(s) must be installed before SQU and JDBC applications can
connect to DB2 databases?

Which list of automatic maintenance parameters can have a policy defined
to specify their automatic behavior?

You have a job scheduled to run every Saturday; the scheduler is turned
off on Friday and then restarted on Monday. The job scheduled for Saturday
is now a job that is scheduled in the past.
Which configuration parameters will allow your Saturday job to run when the
scheduler is restarted?