P2090-068 Online Practice Questions and Answers

The Flexible Grid technology of Informix offers which of the following benefits?

A. The ability to communicate with other non-IBM products.

B. The ability to perform administrative tasks on multiple sites from a single server with no downtime.

C. The ability to replicate data between different versions and editions of Informix.

D. Theability to achieve redundancy using expensive hardware and third party software.

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

A. oninit

B. ondblog

C. onmode

D. ondbmode

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 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.

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

Which of the following Informix security methods protects network data transmitted between a server and a client?

A. Set-column level encryption

B. Cell-level encryption

C. Column-level encryption

D. Network data encryption

Which of the following is a key benefit of Informix?

A. Database extensions can be added to supportnew business problem domains.

B. Chunks can be two gigabytes in size.

C. Uptime of at most 80% can be achieved using continuous availability features.

D. Databases can be administered by a local database administrator.

Which of the following statements aboutFlexible Grid technology is TRUE?

A. It requires high speed interconnect technology between nodes.

B. It works only in a shared disk environment.

C. It requires additional technology for disaster recovery.

D. Both DDL and DML can be performed dynamicallyon all grid nodes from a single server.

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.

Which of the following statements is True about the Onstat utility?

A. It cannot be used to retrieve locking information.

B. It consume a lot of the system's resources andshould be used infrequently.

C. It doesn't place any locks on shared memory.

D. It can be used to view table data.