IBM C2090-619 Online Practice Questions and Exam Preparation

IBM C2090-619 Online Questions & Answers

• Question 21:

  Which approach is always valid when migrating data across differing hardware and operating system architectures?

  A. dbexport source system then dbimport into target.
  B. ontape backup from source then restore backup onto target.
  C. onunload the source to tape and onload the tape to the target.
  D. Set up HDR primary and secondary between source and target.
  A. dbexport source system then dbimport into target.

• Question 22:

  When using the deployment assistant, which two statements are true? (Choose two.)

  A. A java environment must be configured.
  B. The Informix user account must be used.
  C. Chunks can be raw devices or buffered files.
  D. The user must have connect permission to all databases.
  E. The user must have connect privilege to sysadmin database.
  A. A java environment must be configured.
  E. The user must have connect privilege to sysadmin database.

• Question 23:

  Which two statements are true about blobspace? (Choose two.)

  A. The TEXT or BYTE objects are stored in the logical log files.
  B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.
  C. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.
  D. A newly created blobspace is immediately available for storage of TEXT or BYTE data.
  E. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.
  B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.
  E. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

• Question 24:

  Which two actions can you perform with ontape? (Choose two.)

  A. Backup to cloud
  B. Restartable restore
  C. Backup specific storage spaces
  D. Restore specific storage spaces
  E. Parallel backup of storage spaces
  A. Backup to cloud
  D. Restore specific storage spaces

• Question 25:

  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
  D. DS_NONPDQ_QUERY_MEM

• Question 26:

  The following message is received: Lock table overflow - user id user32, session id 54. What action should be taken to prevent this problem in the future?

  A. Run onclean utility to clear the lock table.
  B. Increase the LOCKS configuration parameter.
  C. Turn on the AUTO_TUNE configuration parameter.
  D. Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.
  B. Increase the LOCKS configuration parameter.

• Question 27:

  Which is NOT a feature of onbar backups?

  A. The ability to parallelize backups.
  B. The ability to do a point-in-time restore.
  C. The ability to backup without a storage manager.
  D. The ability to do an external backup using a Storage Area Network.
  C. The ability to backup without a storage manager.

• Question 28:

  When KAIO is available and raw disk is used, which statement is true?

  A. Logical Log IO is performed by the LIO VP.
  B. Physical Log IO is performed by the PIO VP.
  C. Logical Log IO is performed by the KAIO VP.
  D. Physical Log IO is performed by the CPU VP.
  D. Physical Log IO is performed by the CPU VP.

• Question 29:

  What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

  A. Apply the new values for all configuration parameters in memory.
  B. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.
  C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.
  D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.
  C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.

• Question 30:

  Which statement is valid about Data consolidation using send-only replicates?

  A. You can have more than one target server.
  B. You cannot modify a server to change its mode to send-only.
  C. You cannot use this replicate for tables that include TimeSeries columns.
  D. You need to define a different replicate for each send-only primary server.
  C. You cannot use this replicate for tables that include TimeSeries columns.