Question 1 

 

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

Question 2 

 

What is the error in this SQL statement?

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

Question 2 options:

	The CREATE command is incomplete
	The primary key is not constructed correctly.
	There are too many columns designated for the table.

Question 3 

 

(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 

 

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

Question 5 

 

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

	True
	False

 

 

 

 

 

 

 

 

 

 

 

 

Question 6 

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 

 

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

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

Question 8 

 

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 being displayed? 

Question 8 options:

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

Question 9 

 

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 

 

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 is a valid aggregate function:

Question 10 options:

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

 

Attachments:

• 1507978771-CDRO expert.docx