C2090-600 IBM DB2 11.1 DBA for LUW

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.