IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 61:

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

  A. ilogin

  B. instmgr

  C. setnet32

  D. oncmsm

  Correct Answer: C

• Question 62:

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

  A. By limiting the size ofdbspaces.

  B. By removing specific databases.

  C. By removing specific product features.

  D. By removing all free space at the end of a chunk.

  Correct Answer: C

• Question 63:

  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.

  Correct Answer: B

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

  Correct Answer: BD

• Question 65:

  Which connection type can be used for network connections?

  A. Sockets

  B. Named Pipes

  C. Stream Pipes

  D. Shared memory

  Correct Answer: A

• Question 66:

  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?

  A. The instance suspends all processing until the next logical-log file is manually added.

  B. The database server will automatically execute a checkpoint and flush the oldest update to disk.

  C. The database server will make use of any logical-log file available regardless of whether the available file is in sequence or not.

  D. 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 of the logical-log files is completed.

  Correct Answer: A

• Question 67:

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

  A. When you want to change database locale.

  B. When you want to migrate from a 32-bit to a 64-bit port of Informix.

  C. When you want to defragment some of the heavily fragmented tables.

  D. When you want to use new configuration features in the new Informix version.

  Correct Answer: A

• Question 68:

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

  A. FORCE_DML_EXEC

  B. FORCE_DDL_EXEC

  C. ROLLBACK_DML_EXEC

  D. ROLLBACK_DDL_EXEC

  Correct Answer: B

• Question 69:

  The user 'guest' connected to a local database world@lsys and wants to execute the following query:

  What two permissions does the user 'guest' need to access the remote table? (Choose two.)

  A. User 'guest' must have SELECT permission on 'globe'

  B. User 'guest' must have CONNECT permission on 'globe'

  C. User 'guest' must have SELECT permission on 'globe@rsys:position'

  D. User 'guest' must have CONNECT permission on 'globe@rsys:sadm.position'

  E. User 'guest' must have RESOURCE permission on 'world@lsys'

  Correct Answer: BC

• Question 70:

  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.

  Correct Answer: B