Need help!! Even with the Khan videos and reading having a hard time
Need help!! Even with the Khan videos and reading having a hard time
deciphering. Please see attachment for questions.
Question 1(0.5 points)(True/False). In an “ID” column with the data type INTEGER PRIMARY KEY, each value entered for theID must be unique.Question 1 options:TrueFalseQuestion 2(0.5 points)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;Question 3(0.5 points)(True/False). Will this SQL statement create a table calledvehicletype?INSERT INTO vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);Question 3 options:TrueFalse
Question 4(0.5 points)This command was used to create a table:CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);Which of the following would correctly add a row of data to the table?Question 4 options:INSERT INTO VALUES (1,”truck”,”Chevrolet”);INSERT INTO vehicletype VALUES (1, truck, Chevrolet);INSERT INTO vehicletype (1, “truck”, “Chevrolet”);INSERT INTO vehicletype VALUES(1, “truck”, “Chevrolet”);Question 5(0.5 points)(True/False). This command was used to create a table:CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);Will the following instruction add a row to the table?INSERT INTO vehicletype VALUES (1, SUV, Honda);Question 5 options:TrueFalse
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
