.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:

TrueFalse

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

SELECT * FROM vehicletype;

Save

Question 3(0.5 points)

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

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

Question 3 options:

TrueFalse

Save

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 vehicletype VALUES (1, truck, Chevrolet);

INSERT INTO vehicletype VALUES(1, truck, Chevrolet);

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 (1, SUV, Honda);

Question 5 options:

TrueFalse

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.

Save

Question 7(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); and populated with at least 25 rows, which of the following isNOTa valid aggregate function:

Question 7 options:

SELECT MIN(inventoryonhand) FROM vehicletype;

SELECT MAX(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 2009 being displayed?

Question 8 options:

SELECT MIN(year) FROM vehicletype;

SELECT MAX(year) FROM vehicletype;

SELECT AVG(inventoryonhand) FROM vehicletype;

SELECT COUNT(YEAR) FROM vehicletype;

Save

Question 9(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); and populated with at least 25 rows, which of the following isNOTa valid aggregate function:

Question 9 options:

SELECT MAX(inventoryonhand) FROM vehicletype;

SELECT * MAX FROM vehicletype;

Save

Question 10(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); and populated with at least 25 rows, which of the following isa valid aggregate function:

Question 10 options:

SELECT SUM inventoryonhand FROM vehicletype;

SELECT MIN(year) FROM vehicletype;

SELECT MAX(inventoryonhand) FROM typeofvehicle;