IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 41:

  Which tool provides the simplest method for monitoring buffer pool hit ratios?

  A. The BP_HITRATIO administrative view.
  B. The BP_WRITE_IO administrative view.
  C. The MON_GET_BUFFERPOOL table function.
  D. The MON_GET_PAGE_ACCESS_INFO table function.
  A. The BP_HITRATIO administrative view.

• Question 42:

  What is the default user workload class that is created for each database table?

  A. DEFAULT_USER
  B. SYSUSERDEFAULTWLM
  C. SYSDEFAULTUSERWORKLOAD
  D. SYS_DEFAULT_USER_WORKLOAD
  C. SYSDEFAULTUSERWORKLOAD

• Question 43:

  A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?

  A. The first time the database is accessed after the migration.
  B. The first time the CREATE STOGROUP statement is executed.
  C. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.
  D. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.
  B. The first time the CREATE STOGROUP statement is executed.

• Question 44:

  Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?

  A. Columns with low cardinalities
  B. Columns with high cardinalities
  C. Columns involved in roll-in or roll-out of data
  D. Columns involved in equality or range predicate queries
  B. Columns with high cardinalities

• Question 45:

  Which statement about DB2 Merge Backup is FALSE?

  A. It can be used to merge offline backups to build full offline table space backups.
  B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
  C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
  D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
  B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

• Question 46:

  What is the FAILARCHPATH database configuration parameter used for?

  A. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.
  B. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.
  C. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.
  D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.
  D. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.

• Question 47:

  The following query is executed frequently against the SALES table:

  SELECT sales_id, sales_date, sales_person FROM sales;

  If data in the SALES_ID column is unique,

  Which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?

  A. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
  B. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)
  C. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
  D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)
  D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

• Question 48:

  Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

  A. Check constraints
  B. Default constraints
  C. Informational constraints
  D. Referential integrity constraints
  C. Informational constraints

• Question 49:

  What statement regarding Asynchronous index cleanup (AIC) is correct?

  A. AIC removes all invalid index entries that refer to the attached partitions.
  B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
  C. AIC activates a newly attached partition after the index entries have been synchronized.
  D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
  B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

• Question 50:

  What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose two.)

  A. InfiniBand with RDMA (IB)
  B. SCSI RDMA Protocol (SRP)
  C. iSCSI Extensions for RDMA (iSER)
  D. RDMA over Converged Ethernet (RoCE)
  E. Internet Wide Area RDMA Protocol (iWARP)
  A. InfiniBand with RDMA (IB)
  D. RDMA over Converged Ethernet (RoCE)