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 of the following is a valid VP class?

A. PDQ

B. AIO

C. MACH11

D. OBJ

In which of the following scenarios is Informix the best fit?

A. Applications with variable and dynamic data records.

B. Large data warehouses requiring cubing and complex multi-dimensional queries.

C. Applications requiring dedicated hardware as part of the solution.

D. High-transaction OLTP workloads.

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

In which case would an Enterprise Replication (ER) solution be needed over a High Availability Cluster?

A. Servers are running different versions of Informix.

B. Data is being replicated between more than two locations.

C. The Linux operating system is being used.

D. An entire database needs to be replicated.

What is an advantage of using a SPL routine?

A. Increased performance because additional indexes can be selected by the optimizer for complex queries.

B. Increased network utilization since more data is passed between client and server.

C. Increased efficiency since business logic can be centrally maintained and managed on the server.

D. Increased security because SPL routines can only be invoked by Java applications.

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.