Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

1. A. AUTO_PERF
2. B. AUTO_TUNE
3. C. AUTO_CONFIG
4. D. AUTO_ENABLE

Correct Answer: B

Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

1. A. CKPTINTVL
2. B. RA_PAGES
3. C. CLEANERS
4. D. SHMVIRTSIZE

Correct Answer: C

To potentially reduce table extent interleaving, an Informix administrator would execute which storage optimization operation?

1. A. Shrink
2. B. Repack
3. C. Compress
4. D. Defragment

Correct Answer: D

Which configuration parameter can be set to quickly return rows to a user while a query continues processing?

1. A. OPTOFC
2. B. OPTMSG
3. C. OPT_GOAL
4. D. OPTCOMPIND

Correct Answer: C

What security role is required for you to create trusted-context objects?

1. A. AAO
2. B. DBSA
3. C. DBSSO
4. D. DBSECADM

Correct Answer: D