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 statement about Range Clustered Tables (RCT) is correct?

For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE
command?

Which index(es) are created when a multidimensional clustering (MDC) table is defined with only
one dimension?

Which configuration parameter setting(s) are needed to force authentication to happen at the data
source in a federated database environment?

What type of file system is used to store data and logs in a DB2 pureScale environment?

What are two services that the cluster caching facility (CF) provides in a DB2 pureScale
environment? (Choose two.)

An auditor has requested that all activities performed by those with SYSADM or DBADM authority
be tracked. How can this be done with the db2audit tool?

A database administrator needs to create a federated database and configure access to join data
from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects are needed
to establish the specified connections?

Which statement about Q Replication is correct?