Microsoft
98-364 · Question #5
98-364 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
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.
Options
- AAn attribute declared as a primary key cannot contain NULL values.
- BEach attribute should be defined as a primary key separately.
- CA table cannot have two primary keys.
- DProductName is declared as Varchar without specifying the width of the column.
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.