Okay

DatabaseProjectQuiZWK4.docx

Home >Computer Science homework help >Okay

Question 1 (0.5 points)

Question 1 Unsaved

If a primary key is not a unique number for each ID entered in as part of the INSERT command, an error message will be displayed.

Question 1 options:

	True
	False

Save

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;

Save

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

	True
	False

Save

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

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

Save

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

Save

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.

Save

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;

Save

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;

Save

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;

Save