For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
For any given column-organized user table, the associated synopsis table may contain information for VARCHAR and DATETIME data types. SYNOPSIS tables store metadata about the contents of each column, which helps optimize query performance. VARCHAR and DATETIME are common types of data that can be summarized effectively. XML, BLOB, and CLOB are less common to store in SYNOPSIS tables because they are more complex or larger in size, which makes them less suitable for summary statistics used in optimization.
D and E are correct. https://www.ibm.com/docs/en/db2/11.5?topic=organization-synopsis-tables