A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER, CHECK ( i 0 AND j

Question

A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER, CHECK ( i > 0 AND j < 0 ) );

Accepted Answer

A. INSERT INTO sample VALUES (1, 0); D. INSERT INTO sample VALUES (NULL, -4);

Answer

B. INSERT INTO sample VALUES (2, -2);

Answer

C. INSERT INTO sample VALUES (3, NULL);

Answer

E. INSERT INTO sample VALUES (5, -5);

A table named "sample" is defined as below. Select two statements which will generate a constraint error. CREATE TABLE sample ( i INTEGER PRIMARY KEY, j INTEGER, CHECK ( i > 0 AND j < 0 ) );

Question

Options

How the community answered

Community Discussion