Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the following query to create the Product table:

CREATE Product (

ProductID Char (10) NOT NULL,

OrderID Char (10) NULL

ProductName Varchar NOT NULL,

Primary key (OrderID, ProductID))

What are the errors in the above query? Each correct answer represents a complete solution. Choose two.

Question

Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the following query to create the Product table:

CREATE Product (
ProductID Char (10) NOT NULL,
OrderID Char (10) NULL
ProductName Varchar NOT NULL,
Primary key (OrderID, ProductID))

What are the errors in the above query? Each correct answer represents a complete solution. Choose two.

Accepted Answer

A. An attribute declared as a primary key cannot contain NULL values. D. ProductName is declared as Varchar without specifying the width of the column.

Answer

B. Each attribute should be defined as a primary key separately.

Answer

C. A table cannot have two primary keys.

Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the following query to create the Product table: - CREATE Product ( - ProductID Char (10) NOT…

Question

Options

How the community answered

Community Discussion