IFSM 201 Database Quiz Week 4

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 1/4

Question 1 (0.5 points)

Question 2 (0.5 points)

Question 3 (0.5 points)

Question 4 (0.5 points)

Question 5 (0.5 points)

Saved

Saved

Saved

Saved

Saved

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.

True

False

What is the error in this SQL statement?

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

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

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

True

False

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”);

(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?

The CREATE command is incomplete

There are too many columns designated for the table.

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

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

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 2/4

Question 6 (0.5 points)

Question 7 (0.5 points)

Saved

Saved

INSERT INTO vehicletype (1, “SUV”,” Honda”);

True

False

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;

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 6 (six) being displayed?

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.

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 3/4

Question 8 (0.5 points)

Question 9 (0.5 points)

Saved

Saved

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 (two thousand nine) being displayed?

Which of the following is NOT a valid aggregate function?

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(year) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(YEAR) FROM vehicletype;

9/13/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System

https://learn.umuc.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=416120&isprv=&drc=0&qi=1047977&cfql=0&dnb=0 4/4

Question 10 (0.5 points) Saved

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); which of the following is a valid aggregate function:

Submit Quiz 10 of 10 questions saved

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT * MAX FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT SUM(inventoryonhand) FROM vehicletype;

SELECT typeofvehicle FROM vehicletype ORDER BY year;

SELECT SUM (inventoryonhand) FROM manufacturer;

SELECT MIN(year) FROM vehicletype;