Which statement about the OpenAdmin Tool (OAT) for Informix is TRUE?

A. It is only available for Informix Ultimate Edition.

B. It is a separate, add-on feature that is chargeable.

C. It can manage hundreds of local or remote Informix instances.

D. It can manage, monitor, and administer local databases only.

Which of the following statements about the level of compatibility between the backups produced by ontape and ON-Bar is true?

A. You can create a backup with ON-Bar and restore it with ontape, but not vice versa.

B. You can create a backup with ontape and restore it with ON-Bar, but not vice versa.

C. The respective backups are not compatible; you cannot create a backup with ontape and restore it with ON-Bar, or vice versa.

D. The respective backup tapes are compatible; you can create a backup with ontape and restore it with ON-Bar, and vice versa.

Why does a database execute a checkpoint operation?

A. To ensure that runaway queries are stopped before consuming all the system resources.

B. To synchronize the pages in a primary dbspace with a mirrored dbspace.

C. To update statistics for large tables currently being accessed by queries.

D. To synchronize the pages on disk with the pages in the shared-memory buffers.

Which Informix edition, at a minimum, would permit a Global company to deploy multiple database backup sites for protection against man-made or natural disasters? They want to include oneshared disk secondary, as well as one Remote Secondary Server in their plan.

A. Informix Ultimate-C Edition

B. Informix Growth Edition

C. Informix Ultimate Edition

D. Informix Innovator-C Edition

The physical log is usedto do what?

A. Alert the DBA when the system needs maintenance or tuning.

B. Store a copy of a page from the shared-memory buffer pool before it is modified for the first time.

C. Record error information when a severe error is encountered.

D. Store information about the status of used and free space in a dbspace.