Which Data Type Fits the Data?

Question

In which of these cases is the data type a good choice for the data? Choose all that apply.

Answer 1

A product photo - BLOB

Answer 2

An AI embedding for similarity search - VARCHAR with the numbers separated by commas

Answer 3

A set of attributes that differs from product to product - ENUM

Answer 4

A customer's email address - BLOB

Answer 5

A film rating that is always one of G, PG, PG-13, R, NC-17 - ENUM

Answer 6

The location of an airport on the map - POINT

Answer 7

An order identifier generated on many servers at the same time - UUID