IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 21:

  You need to restore a table space that was backed up earlier, but before you begin a restore operation you want to determine whether any tables in the table space were populated with a LOAD ... NONRECOVERABLE operation. What can be used to provide this information?

  A. The INSPECT utility
  B. The db2pd command
  C. The db2dart command
  D. The database recovery history file
  D. The database recovery history file

• Question 22:

  Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?

  A. FEDERATED set to YES
  B. FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
  C. FEDERATED set to YES FED_NOAUTH set to YES
  D. FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT
  D. FEDERATED set to YES FED_NOAUTH set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT

• Question 23:

  What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

  A. AUDIT
  B. VALIDATE
  C. EXECUTE
  D. CONTEXT
  C. EXECUTE

• Question 24:

  Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

  A. One composite block index and one unique index.
  B. One composite clustering index and one dimension block index.
  C. One index that serves as both the dimension block index and the composite block index.
  D. One index that serves as both the dimension block index and the composite clustering index.
  C. One index that serves as both the dimension block index and the composite block index.

• Question 25:

  What must you do before an online table space backup operation can be performed?

  A. Create a full database backup image.
  B. Create one or more tables in the table space.
  C. Create an incremental backup image of the table space.
  D. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.
  A. Create a full database backup image.

• Question 26:

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

  A. Reverse scans on RCTs are not supported.
  B. Clustering indexes are compatible with RCTs.
  C. The Design Advisor can recommend the use of RCTs.
  D. The IMPORT utility can be used with the REPLACE option to populate RCTs.
  A. Reverse scans on RCTs are not supported.

• Question 27:

  Which statement about Q Replication is correct?

  A. It uses continuous log shipping to replicate from the source database to the target database.
  B. It uses HADR message queues to transmit transactions between source and target databases.
  C. It uses WebSphere MQ message queues to transmit transactions between source and target databases.
  D. It uses replication control tables and changed data tables to replicate from the source database to the target database.
  C. It uses WebSphere MQ message queues to transmit transactions between source and target databases.

• Question 28:

  Which diagnostic tool can be used to show high-watermark consumptions of Fast Communication Manager (FCM) buffers and channels?

  A. db2pd
  B. inspect
  C. db2dart
  D. db2mtrk
  A. db2pd

• Question 29:

  Which statement about Range-Clustered Tables (RCTs) is correct?

  A. More logging is required compared to similarly-sized regular tables.
  B. More buffer pool memory is required to store the table's B+ index structure.
  C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.
  D. More maintenance is required since indexes must be updated after every insert, update, or delete operation.
  C. Space is pre-allocated and reserved for use by the table even when records do not yet exist.

• Question 30:

  What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

  A. Call the ADMIN_MOVE_TABLE procedure.
  B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.
  C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.
  D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.
  A. Call the ADMIN_MOVE_TABLE procedure.