IBM C2090-600 Online Practice Questions and Exam Preparation

IBM C2090-600 Online Questions & Answers

• Question 11:

  Which of the following are all valid types of trigger?

  A. AFTER, ATOMIC, BEFORE
  B. AFTER, ATOMIC, INSTEAD OF
  C. AFTER, BEFORE, INSTEAD OF
  D. ATOMIC, BEFORE, INSTEAD OF
  C. AFTER, BEFORE, INSTEAD OF

• Question 12:

  You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

  A. LOAD
  B. INGEST
  C. IMPORT
  D. TRANSPORT
  C. IMPORT

• Question 13:

  Which statement about NOT ENFORCED unique constraints is TRUE?

  A. NOT ENFORCED unique constraints can not be defined on primary key columns
  B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
  C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned
  D. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index
  A. NOT ENFORCED unique constraints can not be defined on primary key columns

• Question 14:

  Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

  A. When the registry variableDB2_AUTORECLAIMSPACE=YES
  B. After termination all the back-end processes using TERMINATE command
  C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
  D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
  C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON

• Question 15:

  Which of the following are valid Explain operators? (Choose two.)

  A. CTQ
  B. XSCAN
  C. IXSCAN
  D. SELECT
  E. COLSCAN
  B. XSCAN
  C. IXSCAN

• Question 16:

  Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

  A. Creating, using, or altering thresholds
  B. Granting, altering, or revoking workload privileges
  C. Using or altering the default service classes and workloads
  D. Creating service classes, service subclasses, and workloads
  E. Creating, activating, stopping or dropping workload management event monitors
  B. Granting, altering, or revoking workload privileges
  D. Creating service classes, service subclasses, and workloads

• Question 17:

  Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

  A. db2pd
  B. db2dart
  C. db2expln
  D. db2advis
  C. db2expln

• Question 18:

  Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

  A. To prunethe contents of a staging table.
  B. To prune the contents of a synopsis table.
  C. To prune the contents of a materialized query table (MQT).
  D. To prune the contents of a declared global temporary table.
  A. To prunethe contents of a staging table.

• Question 19:

  You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

  A. db2cluster -verify
  B. db2cluster -cm -list -alert
  C. db2cluster -verify -configuration
  D. db2cluster -cm -verify -resource
  D. db2cluster -cm -verify -resource

• Question 20:

  Which statement about the db2move command is TRUE?

  A. The LOAD actions can be run from a client machine.
  B. Object ownership cannot be changed after a successful schema copy operation.
  C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
  D. Loading data into tables containing XML columns is only supported for the LOAD actions.
  D. Loading data into tables containing XML columns is only supported for the LOAD actions.