Exam 98-364 topic 1 question 186 discussion

Actual exam question from Microsoft's 98-364

Question #: 186
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: AD 🗳️

by Dbiswas at July 8, 2021, 1:59 p.m.