Need help!! Even with the Khan videos and

Question 1 (0.5 points)

 

(True/False). In an "ID" column with the data type INTEGER PRIMARY KEY, each value entered for the ID must be unique.

Question 1 options:

	True
	False

 

Question 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 called vehicletype?

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

Question 3 options:

	True
	False

 

 

 

 

 

 

 

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 vehicletypeVALUES(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:

	True
	False

 

 

 

 

 

 

 

 

 

 

 

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.
	A list of all the vehicles would be displayed and all trucks manufactured in the same year would be listed together.
	A list of only the trucks would be displayed in the order the rows were entered into the database.

 

 

Question 7 (0.5 points)

 

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema vehicletype  10 rows Id (PK) INTEGER typeofvehicle TEXT manufacturer TEXT year INTEGER inventoryonhand INTEGER

RESULTS Id typeofvehicle manufacturer year inventoryonhand 1 Pickup Chevrolet 2009 12 2 SUV Ford 2017 13 3 SUV Toyota 2015 7 4 Sedan Toyota 2014 8 5 Sedan Ford 2017 10 6 Coupe Hyundai 2010 8 7 Pickup Honda 2015 7 8 Sedan Honda 2017 23 9 SUV Hyundai 2013 6 10 Pickup Ford 2017 16

Which of the following commands would result in a value of 11 being displayed? 

Question 7 options:

	SELECT MIN(inventoryonhand) FROM vehicletype;
	SELECT MAX(inventoryonhand) FROM vehicletype;
	SELECT AVG(inventoryonhand) FROM vehicletype;
	SELECT COUNT(inventoryonhand) FROM vehicletype;

Save

Question 8 (0.5 points)

 

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema vehicletype  10 rows Id (PK) INTEGER typeofvehicle TEXT manufacturer TEXT year INTEGER inventoryonhand INTEGER

RESULTS Id typeofvehicle manufacturer year inventoryonhand 1 Pickup Chevrolet 2009 12 2 SUV Ford 2017 13 3 SUV Toyota 2015 7 4 Sedan Toyota 2014 8 5 Sedan Ford 2017 10 6 Coupe Hyundai 2010 8 7 Pickup Honda 2015 7 8 Sedan Honda 2017 23 9 SUV Hyundai 2013 6 10 Pickup Ford 2017 16

Which of the following commands would result in a value of 23 being displayed?

Question 8 options:

	SELECT SUM(inventoryonhand) FROM vehicletype;
	SELECT MAX(inventoryonhand) FROM vehicletype;
	SELECT MAX(inventoryonhand) FROM typeofvehicle;
	SELECT SUM(inventoryonhand) FROM typeofvehicle;

 

 

 

 

 

 

 

 

 

Question 9 (0.5 points)

 

This table has been created (Database Schema) and populated with values listed in RESULTS.

Database Schema vehicletype  10 rows Id (PK) INTEGER typeofvehicle TEXT manufacturer TEXT year INTEGER inventoryonhand INTEGER

RESULTS Id typeofvehicle manufacturer year inventoryonhand 1 Pickup Chevrolet 2009 12 2 SUV Ford 2017 13 3 SUV Toyota 2015 7 4 Sedan Toyota 2014 8 5 Sedan Ford 2017 10 6 Coupe Hyundai 2010 8 7 Pickup Honda 2015 7 8 Sedan Honda 2017 23 9 SUV Hyundai 2013 6 10 Pickup Ford 2017 16

Which of the following commands would result in a value of 2009 being displayed? 

Question 9 options:

	SELECT MIN(year) FROM vehicletype;
	SELECT MAX(year) FROM vehicletype;
	SELECT AVG(inventoryonhand) FROM vehicletype;
	SELECT COUNT(YEAR) FROM vehicletype;

 

 

Question 10 (0.5 points)

 

 Which of the following is a valid aggregate function:

Question 10 options:

	SELECT * FROM vehicletype ORDER BY manufacturer;
	SELECT typeofvehicle FROM vehicletype ORDER BY year;
	SELECT SUM (inventoryonhand) FROM manufacturer;
	SELECT MIN(year) FROM vehicletype;
	SELECT MAX(inventoryonhand) FROM typeofvehicle;

 

reading having a hard time deciphering. Please see attachment for questions.

Attachments:

• 1507983084-Database Project Quiz.docx