Question 6 (0.5 points)

This command was used to create a table: CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT,year INTEGER);

At least 25 rows have been inserted with different types of vehicles (truck, sedan, SUV, sport) and manufacturer (Chevrolet, Ford, Toyota, etc.), and year the vehicle was manufactured. What would be the result of this command:

Select * FROM vehicletype WHERE typeofvehicle=truck ORDER BY year;

Question 6 options:

A list of all the vehicles in the database would be displayed and ordered by year manufactured.

A list of only the trucks would be displayed and those vehicles would be listed in order of the year the vehicle was manufactured.

Question 7 (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 7 options:

	True
	False

Question 8 (0.5 points)

Assuming that a table has been correctly constructed with the command CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT, year INTEGER, inventoryonhand INTEGER); and populated with at least 25 rows, which of the following is NOT a valid aggregate function:

Question 8 options:

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT SUM(inventoryonhand) FROM vehicletype;

Question 9 (0.5 points)

If this command correctly enters a row of data into a table, which of the following would be the correct command to create that table? INSERT INTO vehicletype VALUES (1, truck, Chevrolet);

Question 9 options:

CREATE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

Question 10 (0.5 points)

(True/False). Will this SQL statement create a table called vehicletype?

CREATE TABLE vehicletype (carid PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT);

Question 10 options:

	True
	False