Which statement is valid about Data consolidation using send-only replicates?

1. A. You can have more than one target server.
2. B. You cannot modify a server to change its mode to send-only.
3. C. You cannot use this replicate for tables that include TimeSeries columns.
4. D. You need to define a different replicate for each send-only primary server.

Correct Answer: C

Which is NOT a feature of onbar backups?

1. A. The ability to parallelize backups.
2. B. The ability to do a point-in-time restore.
3. C. The ability to backup without a storage manager.
4. D. The ability to do an external backup using a Storage Area Network.

Correct Answer: C

Which command line utility does NOT have the equivalent functionality using the SQL Administration API?

1. A. oninit
2. B. onmode
3. C. onspaces
4. D. onparams

Correct Answer: A

An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

1. A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.
2. B. Increase the value of NUMFDSERVERS and add more poll threads.
3. C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.
4. D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

Correct Answer: B

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer (customer_num); Which catalog table data is NOT updated?

1. A. sysdistrib
2. B. systables
3. C. sysindexes
4. D. syscolumns

Correct Answer: A