Question

Which of the following table definitions guarantee that column с1 cannot contain NULL values? Pick all applicable options.

Cosmo · Accepted Answer

PRIMARY KEY cannot contain NULL values

Cosmo · Accepted Answer

CREATE TABLE z1 (c1 INT PRIMARY KEY)

Cosmo · Accepted Answer

CREATE TABLE z1 (c1 INT NOT NULL)

Cosmo · Answer

CREATE TABLE z1 (c1 INT DEFAULT 0)

Cosmo · Answer

CREATE TABLE z1 (c1 INT)