IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows Set 1

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?

To configure instance-level auditing with db2audit, which authority is required?

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?