Starting Out with Python, 6th
Edition by Tony Gaddis
Complete Chapter Solutions Manual
are included (Ch 1 to 14)
** Immediate Download
** Swift Response
** All Chapters included
** Programming Exercises Solutions
** Source Codes
,Solutions Manual organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch14-1)
Chapter 14 Solutions
Checkpoint 14.1-1
When working with a large amount of data, it is best to use a database instead of a traditional
file.
a. True
b. False
Answer: a
Checkpoint 14.1-2
When using a database, programming languages such as Python typically work with a
_____________________, which interacts directly with the data in a database.
a. blockchain generator
b. file server
c. database management system
d. data translator
Answer: c
Checkpoint 14.1-3
This is a standard language for working with DBMSs.
a. Python
b. COBOL
c. SQL
d. BASIC
Answer: c
Checkpoint 14.2-1
The data that is stored in a table is organized in __________.
a. rows
b. files
c. folders
d. pages
Answer: a
Checkpoint 14.2-2
The data that is stored in a row is divided into __________.
a. sections
b. bytes
c. columns
d. tables
Answer: c
,Checkpoint 14.2-3
Suppose a database at the Department of Motor Vehicles has a table that stores driver's license
data. Which of the following pieces of data would be the best choice for the table's primary
key?
a. Driver's height
b. Driver's date of birth
c. Driver's last name
d. Driver's license number
Answer: d
Checkpoint 14.2-4
A table can have more than one primary key.
a. True
b. False
Answer: b
Checkpoint 14.2-5
All identity columns in a table contain the same value.
a. True
b. False
Answer: b
Quiz 14.2 (Scored)
Question 1
This is a column that holds a unique value for each row and can be used to identify specific
rows.
a. ID column
b. public key
c. designator column
d. primary key
Answer: d
Question 2
A(n) ________________ contains unique values that are generated by the DBMS.
a. self-defining column
b. identity column
c. serial number column
d. hash value column
, Answer: b
Question 3
If a column is _______________, it means that each time a new row is added to the table, the
DBMS automatically assigns the column an integer that is 1 greater than the largest value
currently stored in the column.
a. autoincremented
b. pivoted
c. bootstrapped
d. autoappended
Answer: a
Checkpoint 14.3-1
The sqlite3.connect function returns this type of object.
a. Cursor
b. Database
c. File
d. Connection
Answer: d
Checkpoint 14.3-2
What is a Cursor object?
a. An object that opens a connection to a database.
b. An object that can access and modify the rows in a database.
c. An object that gets user input for a database.
d. An object that prevents a database from being corrupted.
Answer: b
Checkpoint 14.3-3
When you make changes to a database, those changes aren’t actually saved in the database
until you commit them.
a. True
b. False
Answer: a
Edition by Tony Gaddis
Complete Chapter Solutions Manual
are included (Ch 1 to 14)
** Immediate Download
** Swift Response
** All Chapters included
** Programming Exercises Solutions
** Source Codes
,Solutions Manual organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch14-1)
Chapter 14 Solutions
Checkpoint 14.1-1
When working with a large amount of data, it is best to use a database instead of a traditional
file.
a. True
b. False
Answer: a
Checkpoint 14.1-2
When using a database, programming languages such as Python typically work with a
_____________________, which interacts directly with the data in a database.
a. blockchain generator
b. file server
c. database management system
d. data translator
Answer: c
Checkpoint 14.1-3
This is a standard language for working with DBMSs.
a. Python
b. COBOL
c. SQL
d. BASIC
Answer: c
Checkpoint 14.2-1
The data that is stored in a table is organized in __________.
a. rows
b. files
c. folders
d. pages
Answer: a
Checkpoint 14.2-2
The data that is stored in a row is divided into __________.
a. sections
b. bytes
c. columns
d. tables
Answer: c
,Checkpoint 14.2-3
Suppose a database at the Department of Motor Vehicles has a table that stores driver's license
data. Which of the following pieces of data would be the best choice for the table's primary
key?
a. Driver's height
b. Driver's date of birth
c. Driver's last name
d. Driver's license number
Answer: d
Checkpoint 14.2-4
A table can have more than one primary key.
a. True
b. False
Answer: b
Checkpoint 14.2-5
All identity columns in a table contain the same value.
a. True
b. False
Answer: b
Quiz 14.2 (Scored)
Question 1
This is a column that holds a unique value for each row and can be used to identify specific
rows.
a. ID column
b. public key
c. designator column
d. primary key
Answer: d
Question 2
A(n) ________________ contains unique values that are generated by the DBMS.
a. self-defining column
b. identity column
c. serial number column
d. hash value column
, Answer: b
Question 3
If a column is _______________, it means that each time a new row is added to the table, the
DBMS automatically assigns the column an integer that is 1 greater than the largest value
currently stored in the column.
a. autoincremented
b. pivoted
c. bootstrapped
d. autoappended
Answer: a
Checkpoint 14.3-1
The sqlite3.connect function returns this type of object.
a. Cursor
b. Database
c. File
d. Connection
Answer: d
Checkpoint 14.3-2
What is a Cursor object?
a. An object that opens a connection to a database.
b. An object that can access and modify the rows in a database.
c. An object that gets user input for a database.
d. An object that prevents a database from being corrupted.
Answer: b
Checkpoint 14.3-3
When you make changes to a database, those changes aren’t actually saved in the database
until you commit them.
a. True
b. False
Answer: a
