IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 61:

  What does this user-defined task/sensor do?

  

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

• Question 62:

  Which onstat command returns an accurate free count of blobspace pages?

  A. onstat -d
  B. onstat -g blb
  C. onstat -d update
  D. onstat -d blobinfo
  C. onstat -d update

• Question 63:

  How is the automatic addition of more space triggered?

  A. Via the default alarm program.
  B. When the instance is restarted.
  C. The internalmon_low_storage task.
  D. When the limit of the ADD_SPACEonconfig parameter is reached.
  C. The internalmon_low_storage task.

• Question 64:

  What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (Choose two.)

  A. When AIO is not available.
  B. When the I/O is to raw disk space.
  C. When the I/O is to buffered file chunks.
  D. When the operating system supports it.
  E. When the KAIOON parameter in ONCONFIG file is set to1.
  B. When the I/O is to raw disk space.
  D. When the operating system supports it.

• Question 65:

  Which statement regarding default roles is true?

  A. An administrator can define a default role to assign only to the PUBLIC group for a particular database.
  B. The privileges associated with a default role takes precedence over the privileges granted to an individual user.
  C. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.
  D. When a user connects to a database, it is necessary to use the SET ROLE DEFAULT statement in order to gain the default role privileges.
  C. An administrator can define a default role to assign to individual users or to the PUBLIC group for a particular database.

• Question 66:

  Given the following SLA definition:

  SLA group_1=HDR+(inst_2+inst_3)+SDS

  How will new connections be routed through the SLA?

  A. Load balanced between all secondary instances.
  B. Load balanced between inst_2 and inst_3, then either HDR or any SD secondary instance.
  C. The HDR instance first, then inst_2, followed by inst_3, finally to any SD secondary instance.
  D. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.
  D. The HDR instance first, load balanced between inst_2 and inst_3, then to any SD secondary instance.

• Question 67:

  Which statement about automatic space management is true?

  A. Spaces cannot be extended manually.
  B. Onlyunmirrored spaces can be extended.
  C. Mirrored andunmirrored spaces can be extended.
  D. The time interval for low storage space checks is not user configurable.
  B. Onlyunmirrored spaces can be extended.

• Question 68:

  When adding space to the storagepool, which correctly describes the type of storage which may be placed in the storagepool?

  A. Cooked file only.
  B. Raw devices only.
  C. Cooked files andRaw devices only.
  D. Cooked files,Raw devices and Directories.
  D. Cooked files,Raw devices and Directories.

• Question 69:

  Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?

  A. ADM
  B. BTS
  C. CPU
  D. CSM
  A. ADM

• Question 70:

  Which statement about in-place migration is true?

  A. In-place migration is possible when an Informix instance is migrated from a non-Informix database management system.
  B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.
  C. In-place migration is possible when an Informix instance is migrated from an older version of Informix on a different operating system.
  D. In-place migration requires that the DBA copy the database schema, user data, and user objects from the older version to the newer version of Informix.
  B. In-place migration is possible when an Informix instance is migrated from an older version of Informix on the same operating system.