IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 111:

  Which tool should be used to collect data during a potential hang without stopping the database manager?

  A. db2ls
  B. db2dart
  C. db2fodc
  D. db2cklog
  C. db2fodc

• Question 112:

  If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?

  A. Self-tuning is occurring only on the instance memory area.
  B. The memory tuner is actively tuning the memory on the system.
  C. Self-tuning is not occurring because it is waiting for the database to be recycled.
  D. Self-tuning is not occurring because there are less than two memory consumers enabled.
  D. Self-tuning is not occurring because there are less than two memory consumers enabled.

• Question 113:

  Which statement about the ADMIN_MOVE_TABLE procedure is true?

  A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.
  B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.
  C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
  D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.
  C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.

• Question 114:

  Which statement about referential constraints is true?

  A. A referential constraint can be defined against a catalog table.
  B. A referential constraint can be defined on both tables and views.
  C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.
  D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.
  C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.

• Question 115:

  Which statement about range-clustered tables is true?

  A. Range-clustered tables can be used with the REORG utility.
  B. Range-clustered tables can be used with multiple-column keys.
  C. Range-clustered tables can be used in a DB2 pureScale environment.
  D. Range-clustered tables can be used with value and default compression.
  B. Range-clustered tables can be used with multiple-column keys.

• Question 116:

  What is the MAX_LOG database configuration parameter used for?

  A. To limit how many log files a single transaction can span.
  B. To limit the percentage of primary log space a running transaction can consume.
  C. To limit the total number of primary and secondary log files a database can consume.
  D. To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.
  B. To limit the percentage of primary log space a running transaction can consume.

• Question 117:

  Which statement is correct when describing trusted contexts?

  A. A trusted context defines a trust relationship for a connection between the database and an external entity.
  B. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.
  C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
  D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.
  A. A trusted context defines a trust relationship for a connection between the database and an external entity.

• Question 118:

  If an MQT named Q1_SALES was created as follows:

  

  Which statement will execute successfully?

  A. DELETE FROM q1_sales
  B. REFRESH TABLE q1_sales
  C. INSERT INTO q1_sales VALUES(80.2)
  D. ALTER TABLE q1_sales REFRESH IMMEDIATE
  B. REFRESH TABLE q1_sales