DB2 10 for z/OS Database Administrator — Question 55

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

Answer options

• A. XML
• B. BLOB
• C. CLOB
• D. VARCHAR
• E. DATETIME

Correct answer: D, E

Explanation

The correct answers are D and E because VARCHAR and DATETIME are common data types that can be included in synopsis tables for user data. The other options, XML, BLOB, and CLOB, are typically not used in synopsis tables as they are more complex or larger data types not suited for summary representation.