98-364 Exam QuestionsBrowse all questions from this exam

98-364 Exam - Question 149


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.)

Show Answer
Correct Answer: AD

An attribute declared as a primary key cannot contain NULL values, which means OrderID cannot be NULL. Additionally, ProductName is declared as Varchar without specifying the width of the column, which is required.

Discussion

1 comment
Sign in to comment
Dbiswas
Jul 8, 2021

C is also correct

anuba
Jul 29, 2021

not because they refer to the table above and there is no 2 PK