A. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

D. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.

B. Issue a LIST UTILITIES statement with the 'SUSPEND <utility ID>' option specified.

C. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.

D. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.

A. Database managed storage with file system caching

B. System managed storage utilizing storage groups

C. System managed storage

D. Automatic storage utilizing storage groups

A. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)

B. CREATE INDEX sales_idx ON sales (sales_person)

C. CREATE INDEX sales_idx ON sales (region, sales_person)

D. CREATE INDEX sales_idx ON sales (region)

A. It uses HADR message queues to transmit transactions between source and target databases.

B. It uses replication control tables and changed data tables to replicate from the source database to the target database.

C. It uses WebSphere MQ message queues to transmit transactions between source and target databases.

D. It uses continuous log shipping to replicate from the source database to the target database.

A. It reads the DB2 recovery log and converts committed transactional data to SQL statements.

B. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.

C. It reads the DB2 recovery log and stores committed transactional data in staging tables.

D. It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.

A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY;

B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10;

C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb;

D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET;

A. SYSCTRL

B. SECADM

C. SYSMAINT

D. SYSADM

A. Statements generating audit records must wait for the records to be written to disk before they can complete execution.

B. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.

C. The audit facility writes records to disk at the same time the statements generating the audit records are executing.

D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.

A. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

B. ALTER TABLESPACE tbsp1 REDUCE MAX

C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

D. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;