← Back to exam page

Free C2090-600 – IBM DB2 11.1 DBA for LUW Practice Test Question

Free demo downloads

Loading demo links...

Showing 4–6 of 10 questions

Question 4

For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    XML
  • ○

    BLOB
  • ○

    CLOB
  • ○

    VARCHAR
  • ○

    DATETIME
Question 5

Which of the following are valid Explain operators? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    CTQ
  • ○

    XSCAN
  • ○

    IXSCAN
  • ○

    SELECT
  • ○

    COLSCAN
Question 6

Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

Select an option, then click Submit answer.

  • ○

    It does not apply to table space backups.
  • ○

    It specifies the compression mode to use for DB2 backups.
  • ○

    It only has effect when appliedto a database in which all tables have been compressed.
  • ○

    If set, backup images created with the BACKUP command are automatically compressed.