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.