At the operating system level, what is thename of every Informix process?

A. informix

B. oninit

C. cpuvp

D. root

Which Informix utility allows you to change the logging mode for one or more databases?

A. oninit

B. ondblog

C. onmode

D. ondbmode

Which utility is used to debug SPL routines?

A. OAT (OpenAdmin Tool)

B. dbaccess.

C. IBM Optim Data Studio

D. dbx.

What is the primary function of the Informix Connection Manager?

A. To monitorand direct the connection requests from client applications to the appropriate server in the high availability cluster.

B. To monitor and maintain the connections between nodes in an Enterprise Replication environment.

C. To monitor and govern SQL statements submitted by client applications.

D. To monitor and report the connection status of the High Availability Data Replication (HDR) secondary server.

Which of the following configurations would suggest that an Informix server is tuned for a DSS workload?

A. PDQPRIORITY is set to the value "HIGH".

B. There are more transactions than queries.

C. Database or table logging is turned on.

D. A task is configured to capture Checkpoint data every two hours.

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 of the following statements about the ontape utility is TRUE?

A. Itcan be used to backup a database to a tape device or file system, or directory.

B. It can be used to backup operating system files in addition to databases.

C. It can be used to backup and restore different storage spaces in parallel.

D. It can be used tobackup a database to tape devices only.

In which segment of database shared memory are bufferpools created by default?

A. Resident portion

B. Flash portion

C. Extended portion

D. Volatile portion

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.