Quiz: Normalization, GeoNames Database, and Anti-Patterns
Test your knowledge of normalization, GeoNames database, and anti-patterns.
We'll cover the following...
We'll cover the following...
Technical Quiz
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
1 / 8