PCPP1 Practice Test 9 — 10 Questions

Question 1

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 2

You have a Tkinter Entry widget and want to retrieve the text currently entered by the user. Which method do you call on the Entry instance?

Accepted Answer

entry.get(). The get() method is used to retrieve the current contents of Entry and Text widgets.

Answer

entry.content()

Answer

entry.text()

Answer

entry.value()

Question 3

How should one handle the 'KeyboardInterrupt' exception if it must be caught for cleanup purposes?

Accepted Answer

Catch it, clean up resources, and then use 'raise'.. You should catch it, perform the cleanup, and then re-raise it so the application still shuts down gracefully.

Answer

Prevent it by setting a signal handler for SIGINT.

Answer

Use a bare 'except:' clause.

Answer

Catch it and ignore it to keep the app running.

Question 4

What is the primary difference between the 'socket.AF_INET' and 'socket.AF_INET6' address families?

Accepted Answer

AF_INET is for IPv4; AF_INET6 is for IPv6. AF_INET is for IPv4, while AF_INET6 is for IPv6 addressing.

Answer

AF_INET6 supports UDP only

Answer

AF_INET requires a password

Answer

AF_INET is faster than AF_INET6

Question 5

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?

Accepted Answer

logging.getLogger('urllib3').setLevel(logging.WARNING). You can configure individual loggers using getLogger() and setting their specific level attribute.

Answer

logging.config.dictConfig({'urllib3': 'WARNING'})

Answer

logging.basicConfig(level=logging.WARNING)

Answer

logging.setLevel('urllib3', logging.WARNING)

Question 6

What is the purpose of the 'socket.shutdown()' method in Python?

Accepted Answer

It stops further communication on the socket. shutdown() allows you to stop sending or receiving data on a socket while keeping the file descriptor open.

Answer

It forces the socket to release its memory

Answer

It resets the socket connection immediately

Answer

It closes the file descriptor completely

Question 7

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?

Accepted Answer

parser.get('section', 'option', fallback='val'). The get() method accepts a 'fallback' argument to return a default value if the option is missing.

Answer

parser.get('section', 'option', default='val')

Answer

parser.get_or_default('section', 'option', 'val')

Answer

parser.exists('section', 'option') ? ...

Answer

parser.get('section', 'option') or 'val'

Question 8

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 9

Which widget is most appropriate for displaying a list of selectable items?

Accepted Answer

tk.Listbox(). The Listbox widget is intended for displaying a list of strings that the user can select.

Answer

tk.Checkbutton()

Answer

tk.OptionMenu()

Answer

tk.Menu()

Question 10

When implementing a timeout in 'requests.get()', what is the consequence of setting it as a single float (e.g., timeout=5)?

Accepted Answer

It limits both the connection and read time to 5 seconds. Providing a single value sets both the connect and read timeouts to that value.

Answer

It only limits the read phase

Answer

It causes an error because a tuple is expected

Answer

It only limits the connection phase