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’);
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’);
β
Correct Answer: (B)
SHOW COLLATION