πŸ“Š MySQL
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
πŸ’¬ Discuss
βœ… Correct Answer: (C) Primary key is missing

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

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

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
116
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Kiran Rapria
Publisher
πŸ“ˆ
92%
Success Rate