IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 71:

  For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?

  A. It will backup just the catalog partition.
  B. It will backup all partitions simultaneously.
  C. It will backup just the partition that the command is executed from.
  D. It will backup just the partitions that reside on the host that the command is executed from.
  C. It will backup just the partition that the command is executed from.

• Question 72:

  The following query is executed frequently against the SALES table:

  SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?

  A. CREATE INDEX sales_idx ON sales (region)
  B. CREATE INDEX sales_idx ON sales (sales_person)
  C. CREATE INDEX sales_idx ON sales (region, sales_person)
  D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
  C. CREATE INDEX sales_idx ON sales (region, sales_person)

• Question 73:

  Which statement about Range Clustered Tables (RCT) is correct?

  A. Storage space is not pre-allocated for an RCT.
  B. The ALTER TABLE statement can be used to change the physical structure of an RCT.
  C. When defining a range of key values for an RCT, a minimum value is optional.
  D. The minimum value of a key column for an RCT cannot be a negative value.
  C. When defining a range of key values for an RCT, a minimum value is optional.

• Question 74:

  The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log):

  MESSAGE:

  ADM5502W

  The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)

  A. LOCKLIST
  B. MAXAPPLS
  C. MAXLOCKS
  D. MAXAGENTS
  E. LOCKTIMEOUT
  A. LOCKLIST
  C. MAXLOCKS

• Question 75:

  A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?

  A. db2dart
  B. db2diag
  C. db2caem
  D. db2fmcu
  B. db2diag

• Question 76:

  What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)

  A. Global Lock Management (GLM)
  B. Group Transaction Routing (GTR)
  C. Automated Member Restart (AMR)
  D. Buffer Pool Synchronization (BPS)
  E. Shared Communications Area (SGA)
  A. Global Lock Management (GLM)
  E. Shared Communications Area (SGA)

• Question 77:

  Given the following output:

  

  Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?

  A. EXPLAIN_FROM_DATA
  B. EXPLAIN_FROM_ACTIVITY
  C. EXPLAIN_FROM_SECTION
  D. EXPLAIN_FROM_CATALOG
  B. EXPLAIN_FROM_ACTIVITY

• Question 78:

  In which situation would you NOT use a redirected restore?

  A. To redefine the paths of a defined storage group.
  B. To move table space containers onto different physical devices.
  C. To restore a backup image from one operating system to another.
  D. To restore a backup image to a target machine that is different from the source machine.
  C. To restore a backup image from one operating system to another.

• Question 79:

  Which statement about compression dictionaries is FALSE?

  A. Page-level dictionaries are stored in hidden rows within the table.
  B. Table-level dictionaries are stored in hidden rows within the table.
  C. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
  D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
  D. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

• Question 80:

  What advantage do block-based buffer pools offer compared to regular buffer pools?

  A. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.
  B. They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.
  C. They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.
  D. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing the blocks into contiguous pages on disk.
  A. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.