Q. Find the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE
CONSTRAINTS pk_person PRIMARY KEY (person_id));
INSERT INTO person
VALUES( person_id, name, LAST, Birth_date)
(1,’s’,’p’, 24-1991-01);

  • (A) In correct data value
  • (B) No error
  • (C) Any other error
  • (D) None of the mentioned
πŸ’¬ Discuss
βœ… Correct Answer: (A) In correct data value
Explanation: This SQL code has a few errors. Let's break them down:
Explanation by: Bhagwan Das
This SQL code has a few errors. Let's break them down:

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
94
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Bhagwan Das
Publisher
πŸ“ˆ
90%
Success Rate