Scenario: A developer needs to store images in a DB2 database. Which data type should they choose for the corresponding column?
- BLOB
- CHAR
- DECIMAL
- VARCHAR
BLOB (Binary Large Object) data type is suitable for storing images in a DB2 database. BLOB allows for the storage of large binary objects, such as images, audio, or video files. It preserves the binary format of the data without any character encoding, making it ideal for non-textual data like images.
Loading...
Related Quiz
- Scenario: A DBA is optimizing a query in DB2 that involves multiple joins and subqueries. The query performance is slow. What strategies can the DBA employ to improve the query performance?
- Database Services in DB2's architecture are responsible for ________.
- What does the version number of DB2 signify?
- What is a common technique used in DB2 for query optimization?
- What are some common methods used to maintain data integrity in a DB2 database?