P2090-068 Online Practice Questions and Answers

Which of the following is a valid VP class?

A. PDQ

B. AIO

C. MACH11

D. OBJ

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

A. oninit

B. ondblog

C. onmode

D. ondbmode

Which of the following administrative processes can Informix handle automatically?

A. Online Archival

B. Storage Provisioning

C. Database schema optimization

D. Datare-distribution

What is an advantage of using Multi-Index scan?

A. Multiprocessor support

B. Multiple disk drive support

C. Index keys are stored in compressed format

D. Less indexes need to be defined on a table

Which of the following is true of the new Storage Provisioning technology in Informix?

A. Dbspaces can only contain one or two chunks.

B. The ability to extend or create new chunks as needed.

C. Indexes are now separated from the data.

D. Table fragments are automatically compressed.

Which type of high availability server does NOT maintain a copy of the entire physical database in its ownisolated disk space?

A. Remote Primary Server (RPS)

B. Remote Standalone Secondary (RSS)

C. Shared-Disk Secondary (SDS)

D. High Availability Data Replication (HDR) Secondary

Which Informix utility is useful in debugging failedtransactions, the time period of a transaction, and changes that are made to a tablespace?

A. onlog

B. onload

C. onbar

D. onunload

What can be used to generate a custom configuration for DSS and/or OLTP environments?

A. onconfig

B. onstat

C. ifxclone

D. genoncfg

What size of business does Informix target?

A. Medium-sized businesses only

B. Small, medium, and large businesses

C. Small businesses only

D. Small businesses with a team of database administrators

TheXYZ Company's failover recovery strategy requires a backup site; however, they do not have a constant or uninterrupted communication link to that site. What type of high availability configuration should be used?

A. Two Shared Disk Secondary (SDS) servers with hardware disk mirroring

B. A High Availability Data Replication (HDR) secondary server running in SYNC mode

C. Continuous Log Restore (CLR) with backup and recovery

D. Enterprise Replication (ER)