IBM Informix 12.10 System Administrator - 000-619 Exam Practice Test

A. Fragment by Range

B. Fragment by Round Robin

C. Partition by Expression

D. Fragment by Expression

A. To display status information about the Informix Warehouse Accelerator and all the data marts.

B. To display update statistics information about the data mart and its tables.

C. To display statistics about the workers and coordinators defined for the accelerator.

D. To display status information about the data mart.

A. cdr realize

B. cdr sync

C. cdr start

D. cdr remaster

A. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.

B. ATS and RIS files must be in XML format.

C. The conflict resolution rule must be always-apply.

D. The replicate must be a mastered replicate.

E. The WHERE clause in the participant definition must include a TimeSeries column.

A. The SDS secondary only.

B. The HDR secondary only.

C. The primary server only.

D. Any server in the cluster.

A. The command defines a template to be realized on servers serv4 and serv5.

B. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.

C. The command defines a template to exclude database testdb from replication.

D. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in
testdb.