Which statement creates a table named products with id as integer primary key and name as varchar(100) not null?

Which statement creates a table named products with id as integer primary key and name as varchar(100) not null?

• A. CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(100) NOT NULL);
• B. CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(100));
• C. CREATE TABLE products (id INT, name VARCHAR(100) NOT NULL);
• D. CREATE TABLE products (id INT PRIMARY KEY, name VARCHAR(99) NOT NULL);

Answer: (A)

The statement tests how to apply constraints correctly in a table definition: give the id column an integer type and declare it as the primary key, and ensure the name column is a non-null string with a maximum length of 100. The best choice does exactly that, declaring id as INT PRIMARY KEY and name as VARCHAR(100) NOT NULL. This satisfies the requirement for a primary key on id (which also implies NOT NULL) and enforces that name must contain a value up to 100 characters. The other options miss one or more requirements: one omits NOT NULL on name, another uses a different string length, and another fails to designate id as the primary key.

The statement tests how to apply constraints correctly in a table definition: give the id column an integer type and declare it as the primary key, and ensure the name column is a non-null string with a maximum length of 100. The best choice does exactly that, declaring id as INT PRIMARY KEY and name as VARCHAR(100) NOT NULL. This satisfies the requirement for a primary key on id (which also implies NOT NULL) and enforces that name must contain a value up to 100 characters. The other options miss one or more requirements: one omits NOT NULL on name, another uses a different string length, and another fails to designate id as the primary key.