A

Admin • 833K Points
Coach

Q. 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’);

  • (A) No error
  • (B) SHOW COLLATION
  • (C) Any other error
  • (D) None of the mentioned
  • Correct Answer - Option(B)
  • Views: 24
  • Filed under category MySQL
  • Hashtags:

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.