Data Models into Database Designs - Technical MCQs

Q1:

A primary key should be defined as:

A NULL

B NOT NULL.

C Either of the above can be used.

D None of the above are correct.

ANS:B - NOT NULL.

Obviously. We don't need to define as not null because whenever it is set the column becomes automatically not null.