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.)
A. An attribute declared as a primary key cannot contain NULL values.
B. Each attribute should be defined as a primary key separately.
C. A table cannot have two primary keys.
D. ProductName is declared as Varchar without specifying the width of the column.
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
 |
