Home / MCQ Bank / Computer

Computer MySQL Difficulty: Medium

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');

Select the correct option to test your answer:

More Computer Questions

What is used for specifying an email to be sent? Which class is used to generate random number? how do you update pivot table report data after changes are made to the source data? When was the IBM XT microcomputer released in the market? What will be the output of the following C code? char str[] ; strcpy(str, "Hello"); res = atoi(str); printf(" %s %d\n", str, res);