IBM IBM Certified Advanced Database Administrator C2090-611 Questions & Answers

• Question 41:

  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.

  Correct Answer: B

• Question 42:

  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.

  Correct Answer: C

• Question 43:

  Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?

  A. XSLPARSE

  B. XSLELEMENT

  C. XSLCONVERT

  D. XSLTRANSFORM

  Correct Answer: D

• Question 44:

  Which table space is NOT created by default when the CREATE DATABASE command is executed?

  A. USERSPACE1

  B. TEMPSPACE1

  C. SYSCATSPACE

  D. SYSTOOLSSPACE

  Correct Answer: D

• Question 45:

  Which statement is correct when describing Range Clustered Tables (RCT) as compared to regular base tables that use at least one index?

  A. RCTs require less logging, less buffer pool space, and less maintenance.

  B. RCTs require more logging, less buffer pool space, and more maintenance.

  C. RCTs require less logging, more buffer pool space, and less maintenance.

  D. RCTs require more logging, more buffer pool space, and less maintenance.

  Correct Answer: A

• Question 46:

  If the following statements are executed in the order shown: Which statement is true?

  

  A. Insert, update, and delete operations can be performed against table TAB2.

  B. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.

  C. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.

  D. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.

  Correct Answer: C

• Question 47:

  When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?

  A. After a SET INTEGRITY statement is executed.

  B. After a truncate table operation is performed in the background.

  C. Immediately after the ALTER TABLE DETACH statement is executed.

  D. Immediately after asynchronous partition detach processing completes for this data partition.

  Correct Answer: D

• Question 48:

  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.

  Correct Answer: C

• Question 49:

  Which SQL data type CANNOT be used to store XML indexed values?

  A. REAL

  B. DOUBLE

  C. DECIMAL

  D. INTEGER

  Correct Answer: A

• Question 50:

  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.

  Correct Answer: A