IBM Informix 11.70 System Administrator

1.

Which storage space should be used to store columns defined as a BLOB or a CLOB?

sbspace dbspace extspace blobspace

2.

What does the SP_WAITTIME variable control?

The maximum time allowed for distributed stored procedures to complete. The maximum amount of wait time for a reply from an H/A cluster secondary. The maximum time a user session will wait for a space extension to complete. The maximum amount of wait time permitted before an automatic space allocation will begin.

3.

Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

SP_AUTOGROW SP_THRESHOLD SP_AUTOEXPAND SP_CHUNKEXTEND

4.

Which statement about automatic space management is true?

Spaces cannot be extended manually. Only unmirrored spaces can be extended. Mirrored and unmirrored spaces can be extended. The time interval for low storage space checks is not user configurable.

5.

Which environment option can rollback transactions using a table involved in an ALTER FRAGMENT ON TABLE operation?

FORCE_DML_EXEC FORCE_DDL_EXEC ROLLBACK_DML_EXEC ROLLBACK_DDL_EXEC

6.

Identify a scenario when you CANNOT use in-place migration?

When you want to change database locale. When you want to migrate from a 32-bit to a 64-bit port of Informix. When you want to defragment some of the heavily fragmented tables. When you want to use new configuration features in the new Informix version.

7.

If the DYNAMIC_LOGS onconfig parameter is set to 1 and logical log backups are not occurring, what will happen in the instance when the last logical-log file fills?

The instance suspends all processing until the next logical-log file is manually added. The database server will automatically execute a checkpoint and flush the oldest update to disk. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not. The database server will stop processing, then start an automatic backup of the logical-log file and resume normal processing once the automatic back up ofthe logical-log files is completed.

8.

Which connection type can be used for network connections?

Sockets Named Pipes Stream Pipes Shared memory

9.

Which Windows utility is used to configure the SQLHOSTS registry key?

ilogin instmgr setnet32 oncmsm

10.

How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

By limiting the size of dbspaces. By removing specific databases. By removing specific product features. By removing all free space at the end of a chunk.

IBM Informix 11.70 System Administrator

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Informix 11.70 System Administrator

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner