Q446
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.
Error, Duplicate value
AnswerC.
Any other error
D.
None of the mentioned
Answer: Option B
Solution
Answer: Option B
No explanation is given for this question Let's Discuss on Board