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 film rating that is always one of G, PG, PG-13, R, NC-17 — ENUM

Answer 2

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

Answer 3

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

Answer 4

A product photo — BLOB

Answer 5

The location of an airport on the map — POINT

Answer 6

A customer's email address — BLOB

Answer 7

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

Practice