Which configuration parameter should be set to enable asynchronous page requests when the database server detects that a query is waiting on I/O?

1. A. DIRECT_IO
2. B. DBUPSPACE
3. C. AUTO_AIOVPS
4. D. AUTO_READAHEAD

Correct Answer: D

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

1. A. onbar -E
2. B. dbexport
3. C. onsmsync
4. D. ontape -exp

Correct Answer: C

Which approach is always valid when migrating data across differing hardware and operating system architectures?

1. A. dbexport source system then dbimport into target.
2. B. ontape backup from source then restore backup onto target.
3. C. onunload the source to tape and onload the tape to the target.
4. D. Set up HDR primary and secondary between source and target.

Correct Answer: A

Consider the following statements: DBSPACETEMP=tempdbs1, tempdbs2, tempdbs3; CREATE DATABASE mydb WITH LOG IN datadbs1; CREATE TEMP TABLE temp1 (col1
int); Which statement is true?

1. A. The temp table will be created in datadbs1.
2. B. The temp table will be created in root dbspace.
3. C. The temp table will be careated in one of the dbspaces listed in DBSPACTEMP.
4. D. The temp table will be created round-robin across the dbspaces in DBSPACETEMP.

Correct Answer: B

What is the purpose of the ifx_getMartStat() function?

1. A. To display status information about the data mart.
2. B. To display update statistics information about the data mart and its tables.
3. C. To display statistics about the workers and coordinators defined for the accelerator.
4. D. To display status information about the Informix Warehouse Accelerator and all the data marts.

Correct Answer: A