What type of argument does executemany() expect for the parameter sets?

A sequence of sequences, such as a list of tuples

A string containing SQL statements

In a CREATE TABLE statement, what does the column definition 'name TEXT' specify?

A column named 'name' that stores text data

A table named 'name' with a text column

A column named 'TEXT' that stores name data

A text column with a default value of 'name'

A developer is writing a unit test that needs to create a temporary SQLite database that exists only in memory and is destroyed when the connection closes. Which connection call is correct?

conn = sqlite3.connect(':memory:')

conn = sqlite3.connect('temp.db')

What is the purpose of the WHERE clause in an UPDATE statement?

To sort the rows before updating

To specify which rows should be updated

To specify the new values for the columns

Python InstitutePCPP1 - Certified Professional Python Programmer 1

Domain 5Objective 1

PCPP-32-101 5.1 Database Programming in Python PCPP-32-1 Practice Questions (Page 1)

Part of the File Processing and Communicating with a Programs Environment domain, which accounts for 15% of the PCPP-32-1 exam. Python Institute does not publish an official question count, but from its 65-minute exam (~25–45 total, ~4–7 in this domain), expect 2–4 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

14concepts

15%of the exam

Questions 1–5

1foundation · easy
What type of argument does executemany() expect for the parameter sets?
Select an answer first
2foundation · easy
In a CREATE TABLE statement, what does the column definition 'name TEXT' specify?
Select an answer first
3application · easy
A developer is writing a unit test that needs to create a temporary SQLite database that exists only in memory and is destroyed when the connection closes. Which connection call is correct?
Select an answer first
4foundation · easy
What is the purpose of the WHERE clause in an UPDATE statement?
Select an answer first
5foundation · easy
Which SQL statement is used to remove rows from a table?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PCPP-32-1

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Python Institute. “PCPP-32-1” is a trademark of its owner, used for identification only.