IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 21:

  When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

  A. They are automatically dropped.
  B. They are marked as "Move Pending."
  C. They are marked as "Dropped Pending."
  D. They are automatically moved to the new table space.
  C. They are marked as "Dropped Pending."

• Question 22:

  Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

  A. DBADM
  B. SYSADM
  C. SQLADM
  D. SECADM
  D. SECADM

• Question 23:

  Which command is used to import connectivity configuration information from a file known as a configuration profile?

  A. db2ca
  B. db2cfexp
  C. db2cfimp
  D. db2cfgimp
  C. db2cfimp

• Question 24:

  Which statement about adaptive compression is true?

  A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.
  B. You can specify that tables be compressed by using either a table-level dictionary only, page-level dictionaries only, or both table-level andpage-level dictionaries.
  C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.
  D. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.
  A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.

• Question 25:

  Which statement regarding compression for temporary tables is true?

  A. Temporary tables can only be compressed using adaptive compression.
  B. Temporary tables can only be compressed using classic row compression.
  C. Compression for temporary tables can be dynamically enabled and disabled.
  D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.
  B. Temporary tables can only be compressed using classic row compression.

• Question 26:

  In IBM Data Studio, where can you schedule script-based jobs?

  A. Job Console
  B. Job Manager
  C. Task Manager
  D. Utilities Console
  B. Job Manager

• Question 27:

  What can be used to provide input to the Design Advisor?

  A. An XML file.
  B. A query workload file.
  C. The database configuration file.
  D. The database manager configuration file.
  B. A query workload file.

• Question 28:

  Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

  A. The table is not a system temporary table.
  B. The table contains a sufficient amount of data.
  C. A table-level compression dictionary does not already exist for the table.
  D. A page-level compression dictionary does not already exist for the table.
  E. The table does not have any indexes defined on it that have not been enabled for compression.
  B. The table contains a sufficient amount of data.
  C. A table-level compression dictionary does not already exist for the table.

• Question 29:

  Which statement is NOT true about a database restore operation?

  A. A table space restore operation must be done offline.
  B. A table space is not usable until the restore operation completes successfully.
  C. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
  D. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
  A. A table space restore operation must be done offline.

• Question 30:

  Which of the following table types is NOT supported by the load utility?

  A. A Temporal table
  B. A Range Partitioned table
  C. A Global Temporary table
  D. A Multidimensional Clustering table
  C. A Global Temporary table