ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Find the error in the following SQL statement?
CREATE TABLE person
( person_id SMALLINT, name VARCHAR, LAST VARCHAR
  CONSTRAINTS pk_person PRIMARY KEY (person_id));
  INSERT INTO person
  VALUES( person_id, name, LAST)
  (1, ’s’, ’p’);
  INSERT INTO person
  ( person_id, name, LAST)
  VALUES(1,’s’,’p’);

Answer & Solution
Correct Answer: Option B
Let's discuss the solution. Join the discussion
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.