Which of the following commands contains an error?
question 2 options:
create vehicletype (carid integer primary key, typeofvehicle text, manufacturer text, year integer);
insert into vehicletype values (1,"truck","ford",2000);
select * from vehicletype;

The very first command contains an error.

Explanation:

The create query is used to create the table in the database. The syntax of the create query is :

create table tablename(column1 datatype,column2 datatype columnn datatype);

So there is a keyword table is missing in the given query. so it is incorrect query.

INSERT INTO vehicletype VALUES (1,"truck","Ford",2000); This query is correct.

SELECT * FROM vehicletype; This query is also correct.

(because i need 20 chars)