Library Modules

When using sqlite3.Row, what is the primary benefit over using a standard tuple?

You are using configparser.ConfigParser to read a configuration file. You have a file where option names are case-sensitive. How do you ensure the parser respects this casing?

You are processing a CSV file using csv.DictReader. If your input file lacks a header row, how do you provide the field names?

When parsing an XML document using xml.etree.ElementTree, you want to find all 'item' tags that are immediate children of the root element. Which method is most efficient for this?

Which method in the xml.dom.minidom module is used to retrieve the value of a specific attribute of an element?

You need to configure the logging module to capture logs from multiple modules while ensuring that logs from third-party libraries (e.g., 'urllib3') are only captured at the WARNING level. How do you set this?

You are using the sqlite3 module to manage a database. You need to ensure that database changes are permanently saved even if your script terminates unexpectedly. Which method should you call after an INSERT operation?

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

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

Which class in xml.etree.ElementTree should you use to parse an XML file from a file object?

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

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

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

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

What is the result of using '?' as a placeholder in sqlite3 for a parameter that is a Python list?

In xml.etree.ElementTree, what is the difference between find() and findall() when used with XPath support?

When using configparser, how do you handle multiline values?

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

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?

Which logging configuration would effectively suppress all log messages?

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

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

You want to retrieve a list of all section names from a ConfigParser object. How do you do this?

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

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

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

What is the purpose of the logging.StreamHandler?

Which THREE of the following are valid parameters for the csv.writer constructor?

You are using configparser and want to access a value that might not exist, but provide a default value if it is missing. Which method is most appropriate?

Which TWO of the following are true about the logging module?

Which TWO of the following are valid ways to read sections in a configparser object?

Which THREE of the following are valid methods of the xml.etree.ElementTree.Element class?

Which THREE of the following are valid states/modes for the csv.QUOTE_* constants?

Which TWO of the following are true about the sqlite3.Cursor object?

Which THREE of the following are components of the logging module?

Which TWO of the following are valid ways to define a configuration option in configparser?

Which TWO of the following are required to successfully write a row to a CSV file?

Which THREE of the following are valid logging levels?