IBM C2090-611 Online Practice Questions and Exam Preparation

IBM C2090-611 Online Questions & Answers

• Question 11:

  Which XML format provides a faster way to transmit and receive XML data between Java pureXML applications and a DB2 server?

  A. String
  B. Binary
  C. Delimited ASCII
  D. Non-delimited ASCII
  B. Binary

• Question 12:

  Which type of table space can be associated with only one storage group?

  A. Automatic storage space (AS)
  B. System managed space (SMS)
  C. Database managed space (DMS) File
  D. Database managed space (DMS) Device
  A. Automatic storage space (AS)

• Question 13:

  Which statement about insert time clustering tables (ITC) is true?

  A. ITC tables cannot be range-partitioned tables.
  B. ITC tables are supported in DB2 pureScale environments.
  C. Rows of an ITC table are clustered by the time they are inserted into the table.
  D. If an ITC table is clustered by one or more user specified dimensions, the specified dimensions must be timestamps.
  C. Rows of an ITC table are clustered by the time they are inserted into the table.

• Question 14:

  Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

  A. SYNC (synchronous)
  B. ASYNC (asynchronous)
  C. NEARSYNC (near synchronous)
  D. SUPERASYNC (super asynchronous)
  D. SUPERASYNC (super asynchronous)

• Question 15:

  The values of the automatic maintenance database configuration parameters for a database named SAMPLE are as follows:

  

  What commands must be run to enable real-time statistics collection on the SAMPLE database?

  A. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
  B. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;
  C. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
  D. UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;
  B. UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

• Question 16:

  A table named SALES was created as follows:

  

  If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

  A. Associate the SEC_POLICY security policy with the SALES table.
  B. Add a column with the DB2SECURITYLABEL data type to the SALES table.
  C. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.
  D. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.
  C. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

• Question 17:

  You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?

  A. Assign the value ON to the DB2_HADR_ROS registry variable.
  B. Assign the value ON to the DB2_HADR_SNAP registry variable.
  C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
  D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
  A. Assign the value ON to the DB2_HADR_ROS registry variable.

• Question 18:

  Which is the suggested way to restore a database with a subset of its original table spaces?

  A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
  B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
  C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN IMAGE option and specify the set of table spacesthat are needed.
  D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES IN DATABASE option and specify the set of tablespaces that are needed.
  A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.

• Question 19:

  Which DB2 product/feature should be used if you want to enable client reroute for transactions and connections based on workload?

  A. pureScale
  B. Advanced Server Edition
  C. Data Partitioning Feature
  D. Enterprise Server Edition
  A. pureScale

• Question 20:

  How can you remove all effects of compression from an index?

  A. Execute the ALTER INDEX statement to turn compression off.
  B. Execute the ALTER TABLE statement to turn compression off.
  C. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.
  D. Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.
  C. Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to removed the compression dictionary.