PCPP1 Library Modules Practice Test 3 — 15 Questions

Question 1

When using configparser, how do you retrieve a value as a boolean?

Accepted Answer

parser.getboolean('section', 'option'). The getboolean() method converts common truthy/falsy values automatically.

Answer

parser.get('section', 'option', type=bool)

Answer

parser.get_bool('section', 'option')

Answer

bool(parser.get('section', 'option'))

Question 2

In the csv module, how do you specify that the CSV file uses a semicolon (;) as a delimiter?

Accepted Answer

csv.reader(f, delimiter=';'). The delimiter parameter in the csv.reader or csv.writer function is used for this purpose.

Answer

csv.reader(f, char=';')

Answer

csv.reader(f, sep=';')

Answer

csv.reader(f, quotechar=';')

Question 3

You are logging events with custom levels. How do you add a custom level 'TRACE' (value 5) to the logging module?

Accepted Answer

logging.addLevelName(5, 'TRACE'). You use logging.addLevelName() to associate a numerical value with a level name.

Answer

logging.TRACE = 5

Answer

logging.setLevel('TRACE', 5)

Answer

logging.define_level('TRACE', 5)

Question 4

When executing a SQL query with parameters in sqlite3, why should you use placeholders (e.g., ?) rather than f-strings?

Accepted Answer

It prevents SQL injection vulnerabilities.. Using placeholders prevents SQL injection attacks and allows the library to handle type conversions.

Answer

It is required for SELECT queries only.

Answer

It enables automatic commit behavior.

Answer

It is faster to execute.

Question 5

You are configuring logging using a dictConfig. You want to send logs to a RotatingFileHandler. Which key must you define in the 'handlers' section?

Accepted Answer

class. The 'class' key is required to specify the handler type, e.g., 'logging.handlers.RotatingFileHandler'.

Answer

destination

Answer

type

Answer

handler_type

Question 6

When using configparser, what happens if you attempt to read a configuration file that does not exist using the read() method?

Accepted Answer

It returns an empty list.. The read() method returns an empty list and does not raise an exception.

Answer

It raises a FileNotFoundError.

Answer

It raises a configparser.Error.

Answer

It creates an empty configuration object.

Question 7

When using configparser, how do you handle multiline values?

Accepted Answer

Indent the subsequent lines.. You indent lines following the initial line within the option.

Answer

Use a backslash at the end of each line.

Answer

Wrap them in triple quotes ('''...''').

Answer

Use the '
' escape character.

Question 8

When parsing XML with ElementTree, how do you retrieve the text content of an element?

Accepted Answer

element.text. The .text attribute of the Element object holds the text content.

Answer

element.content

Answer

element.value

Answer

element.get_text()

Question 9

You are writing to a CSV file. If your data contains the delimiter character itself (e.g., a comma in a text field), what does the csv module do by default?

Accepted Answer

It quotes the field.. The csv module automatically wraps such fields in quotes.

Answer

It raises a csv.Error.

Answer

It ignores the delimiter.

Answer

It escapes the character with a backslash.

Question 10

You are configuring a logging FileHandler. What does the 'mode' parameter control?

Accepted Answer

The file opening mode.. The 'mode' parameter controls the file opening mode (e.g., 'a' for append, 'w' for write).

Answer

The log format.

Answer

The rotation interval.

Answer

The character encoding.

Question 11

You want to execute multiple SQL statements at once in sqlite3. Which method should you use?

Accepted Answer

cursor.executescript(). The executescript() method allows executing multiple SQL statements separated by semicolons.

Answer

connection.execute_all()

Answer

cursor.execute_script()

Answer

cursor.execute_many()

Question 12

You are using sqlite3 and need to enforce foreign key constraints. How do you enable them?

Accepted Answer

connection.execute('PRAGMA foreign_keys = ON'). You must execute the command 'PRAGMA foreign_keys = ON;' on the connection.

Answer

It is enabled by default.

Answer

connection.execute('SET FOREIGN_KEYS ON')

Answer

connection.enable_foreign_keys()

Question 13

In the context of the CSV module, what is a 'dialect'?

Accepted Answer

A set of parameters defining a CSV format.. A dialect is a grouping of parameters (delimiter, quotechar, etc.) that defines the format of a CSV file.

Answer

A specific file extension.

Answer

The encoding of the file.

Answer

A list of column names.

Question 14

Which TWO of the following are valid ways to create a connection in the sqlite3 module?

Accepted Answer

sqlite3.connect(':memory:'). Option A, sqlite3.connect(':memory:'), is correct because sqlite3.connect() is the module's factory function for creating a Connection object, and passing the special filename ':memory:' opens a temporary in-memory database. Option C, sqlite3.connect('my_db.sqlite'), is also correct because the same sqlite3.connect() function accepts a filesystem path and returns a Connection to that database file, creating it if it does not exist. The other options are invalid: sqlite3.Connection is the class of connection objects and is not normally instantiated directly with a filename, while sqlite3.new_db and sqlite3.open are not functions provided by the sqlite3 module.

Answer

sqlite3.Connection('my_db.sqlite')

Answer

sqlite3.new_db('my_db.sqlite')

Answer

sqlite3.open('my_db.sqlite')

Question 15

What is the purpose of the logging.StreamHandler?

Accepted Answer

To send logs to a stream like stdout.. It sends log messages to a stream, such as sys.stderr or sys.stdout.

Answer

To write logs to a file.

Answer

To format log messages.

Answer

To rotate log files.