IBM Informix 12.10 System Administrator - C2090-619 FREE EXAM DUMPS QUESTIONS & ANSWERS

A. All built-in extensions are automatically registered each time the database sever is started. B. All built-in extensions are automatically registered when the extension is first accessed. C. All built-in extensions are automatically registered when the database server is first initialized. D. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

A. Multi Index Join B. ANSI Join C. Index Self-Join D. Star Join

A. cdr start B. cdr remaster C. cdr sync D. cdr realize

A. The table table1 should have col1 as its primary key. B. The table table1 should have CRCOLS shadow columns. C. The table table1 should have a constraint on column col1. D. The table table1 should have an unique index on column col2.

A. They do not obey transaction isolation modes. B. They are recoverable. C. Smart large objects within table rows are not required to be retrieved in one statement. D. They have read, write, and seek properties similar to a standard UNIX file.

A. INFORMIXSHMLCK B. SHMBASE C. RESIDENT D. SHMSEG

A. The conflict resolution rule must be always-apply. B. The replicate must be a mastered replicate. C. ATS and RIS files must be in XML format. D. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server. E. The WHERE clause in the participant definition must include a TimeSeries column.

A. A compressed index cannot be uncompressed. B. A compressed index can be uncompressed. C. A new index can be created compressed. D. Attached indexes cannot be compressed.

A. RA_PAGES B. CLEANERS C. SHMVIRTSIZE D. CKPTINTVL

A. Automatic checkpoints cause the database server to trigger more frequent checkpoints. B. Automatic checkpoints can be dynamically enabled or disabled by using onmode -wm or onmode -wf. C. Automatic checkpoints cause less logical log activity. D. Automatic checkpoints try to avoid transaction blocking.