IBM Informix 11.70 System Administrator Set 2

1.

Which utility requires database logging be turned off to load a table?

load dbload onload dbimport

2.

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.

3.

Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?

Connection type. Number of listener threads. Host name and service name. Database server name or alias.

4.

Which of the following is NOT in the machine notes?

Operating system requirements. Critical kernel tuning parameters. A descriptive list of the new features in the port. Features that are not available for the version and O/S.

5.

Which utilities CANNOT be used to migrate an Informix instance from one hardware vendor to a different hardware vendor?

dbacess unload and dbload onunload and onload dbexport and dbimport High Performance Loader (HPL)

6.

Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

rootdbs. The dbspace the database was created in. One of the dbspaces listed in the DBSPACETEMP environment variable. One of the dbspaces listed in the DBSPACETEMP configuration parameter.

7.

What does this user-defined task/sensor do?

Sensor that stores checkpoint information (onstat -g ckp) in the system. Task that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday. Task that forces a checkpoint every 20 minutes from 10am to 10pm, Monday to Friday. Sensor that forces a checkpoint every 2 minutes from 10am to 10pm, Monday to Friday.

8.

When running an onstat -u, what does a Y in the first column of the flags signify?

The userthread is waiting on a condition. The userthread is waiting for end user I/O to complete. The userthread is waiting for a thread to yield a cpu vp. The userthread is waiting for a thread with a higher priority.

9.

By default, the alarm program gets executed for which event(s)?

All events. Only for events with Severity code 1. Only for events with Severity code 5. Only for events with Severity code greater than 1.

10.

Which command line utility displays real time statistics about the instance?

dbinfo onstat dbschema onmachinfo

IBM Informix 11.70 System Administrator Set 2

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 Set 2

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