IBM Assessment: Informix Server 12.10 Assessment - A2090-619 Exam Practice Test

A. You cannot use this replicate for tables that include TimeSeries columns.

B. You need to define a different replicate for each send-only primary server.

C. You can have more than one target server.

D. You cannot modify a server to change its mode to send-only.

A. RESIDENT

B. SHMSEG

C. SHMBASE

D. INFORMIXSHMLCK

A. Automatic addition of a CPU VP.

B. Automatic addition of an ADM VP.

C. Automatic addition of message log files.

D. Automatic extension of storage spaces.

A. SHMVIRTSIZE

B. RA_PAGES

C. CKPTINTVL

D. CLEANERS

A. Only user root and informix.

B. Any user who is granted privileges to connect to the sysadmin database.

C. Only a user of the DBSA group with privilege to connect to the sysadmin database.

D. Any user of the DBSA group.

A. The SELECT query will return results from store1 and store2.

B. The SELECT query will return results from store3 and store4.

C. The SELECT query will return results from all grid servers.

D. The SELECT query is not a GRID query.

A. The table table1 should have col1 as its primary key.

B. The table table1 should have an unique index on column col2.

C. The table table1 should have a constraint on column col1.

D. The table table1 should have CRCOLS shadow columns.

A. All DataBlades located in the $INFORMIXDIR/extend are automatically registered.

B. All built-in extensions are automatically registered each time the database sever is started.

C. All built-in extensions are automatically registered when the database server is first initialized.

D. All built-in extensions are automatically registered when the extension is first accessed.