A2090-619 Online Practice Questions and Answers

Which statement is FALSE regarding SBSPACES?

A. They are recoverable.

B. They do not obey transaction isolation modes.

C. They have read, write, and seek properties similar to a standard UNIX file.

D. Smart large objects within table rows are not required to be retrieved in one statement.

Which type of device does Primary Storage Manager support?

A. File

B. Tape

C. Directory

D. Named pipe

Which two types of locks are used by Informix to access a shared memory buffer? (Choose two.)

A. Byte

B. Shared

C. Update

D. Exclusive

E. Promotable

When you take a level 2 backup, what data is backed up?

A. All new data since the last level 1 backup.

B. All new data since the last level 2 backup.

C. All logical logs which have not previously been backed up.

D. All new data since the last level 0, level 1 or level 2 backup.

What are two requirements for the "ifxclone" utility? (Choose two.)

A. All databases must use logging.

B. The source server must be a secondary server.

C. Only one server clone process can occur at a time.

D. Both the source and target servers must be part of a trusted network environment.

E. Both the source and target servers must use the same type of disk space (raw or cooked).

The purge policy CANNOT be executed for a rolling window table utilizing which method?

A. By calling the syspurge function.

B. By the purge_tables task of the Scheduler.

C. By setting up the server to automatically run the purge policy.

D. By running ALTER FRAGMENT with the PURGE NOW predicate.

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

A. The user encounters a lock request error.

B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

What data migration tool(s) should be used to load data from a non-Informix data source?

A. dbimport

B. onload and dbload

C. dbload and High Performance Loader

D. onload and High Performance Loader

Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?

A. DBUPSPACE

B. DS_POOLSIZE

C. VP_MEMORY_CACHE_KB

D. DS_NONPDQ_QUERY_MEM

The IBM Mobile Database is a mobile-optimized version of which IBM product?

A. IBM DB2

B. IBM Informix

C. IBM solidDB

D. IBM Cloudscape