CompTIA Data+ DA0-002 (V2) Practice Question

The Character Large Object (CLOB) data type is intended for very large blocks of text-often up to several gigabytes-while still allowing the database engine to treat the content as character data. Because the data remain in a character-encoded form, built-in SQL text operations (e.g., LIKE, SUBSTRING) can be applied. A BLOB, by contrast, stores raw binary data and does not natively support text functions. Standard VARCHAR columns are limited to a few thousand bytes in most platforms (for example, 2-4 KB) and therefore cannot hold 200 KB of text. Numeric types such as FLOAT are meant for numbers, not text. Hence, CLOB is the most appropriate choice.