Que: Find out the logical error in the following MySQL code snippet?

   CREATE TABLE person
   ( person_id VARCHAR(20),
    Name VARCHAR (20),
    Address VARCHAR (20),
    Mobile_no  SMALLINT 
    );
a. Lesser number of columns
b. Incorrect definition
c. Primary key is missing
d. None of the mentioned
Answer: Primary key is missing

Leave a Comment