Given these statements are executed:

which statement is true?

1. A. The entire query will be accelerated to Informix Warehouse Accelerator (IWA) including the OLAP operators.
2. B. The entire query will be executed on Informix database server, and no portion of it will be accelerated by Informix Warehouse Accelerator (IWA).
3. C. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query is accelerated to Informix Warehouse Accelerator (IWA), andOLAP expressions are evaluated by Informix database server.
4. D. The underlying SELECT, JOIN, GROUP BY, and PROJECT operation of the query will be executed by Informix database server, and the OLAP expressions are evaluated by Informix Warehouse Accelerator (IWA).

Correct Answer: C

Which object can be compressed?

1. A. dictionary table
2. B. temporary table
3. C. attached b-tree index
4. D. detached b-tree index

Correct Answer: D

Which statement is FALSE?

1. A. A new index can be created compressed.
2. B. Attached indexes cannot be compressed.
3. C. A compressed index can be uncompressed.
4. D. A compressed index cannot be uncompressed.

Correct Answer: C

What are two requirements for the "ifxclone" utility? (Choose two.)

1. A. All databases must use logging.
2. B. The source server must be a secondary server.
3. C. Only one server clone process can occur at a time.
4. D. Both the source and target servers must be part of a trusted network environment.
5. E. Both the source and target servers must use the same type of disk space (raw or cooked).

Correct Answer: CD

When configuring Informix server for DRDA connection, which statement is true?

1. A. The connection protocol must be drsoctcp.
2. B. The database server name for DRDA connection must correspond to the DBSERVERNAME onconfig parameter.
3. C. The database server name for DRDA connection must correspond to the DBSERVERALIASES onconfig parameter.
4. D. The database server name should correspond to either the DBSERVERNAME or the DBSERVERALIASES onconfig parameter.

Correct Answer: C