Computer scienceFundamentalsSQL and DatabasesBasics SQLData Definition Language

CHECK constraint

Null value

Report a typo

CREATE TABLE table1 (
    c1 INTEGER CHECK (c1 > 0),
    c2 INTEGER CHECK (c2 > 0)
);

Which of the following insert statements will throw an error?

Select one or more options from the list

INSERT INTO table1 VALUES (0, 1);

INSERT INTO table1 VALUES (NULL, NULL);

INSERT INTO table1 VALUES (NULL, 1);

INSERT INTO table1 VALUES (1, 1);

___

Create a free account to access the full topic