Quiz: Normalization, GeoNames Database, and Anti-Patterns

Test your knowledge of normalization, GeoNames database, and anti-patterns.

1

For this table, if you want the price column to contain only positive value, what would be the right option?

CREATE TABLE products (
    product_no integer,
    name text,
    price numeric
);
A)
price numeric
CHECK (price < 0)
B)
price numeric
CHECK (price > 0)
C)
price numeric > 0
D)
price numeric CHECK > 0
Question 1 of 80 attempted

Get hands-on with 1400+ tech skills courses.