A

Admin • 833K Points
Coach

Q. 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) NO_DATE_WITH_ZERO
  • (C) Primary key is missing
  • (D) None of the mentioned
  • Correct Answer - Option(C)
  • Views: 31
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

This code snippet is trying to create a table named "person" with four columns:

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.