PCPP-32-101 PCPP1 – Certified Professional in Python Programming 1 Questions and Answers

The correct answers are C and D. In Python’s sqlite3 module, the string ':memory:' is passed to sqlite3.connect() to create an in-memory SQLite database. This establishes a valid database connection, but the database exists only in RAM and normally disappears when the connection is closed. It is useful for testing, temporary storage, fast operations, and examples where no persistent database file is required. Option A is wrong because :memory: does not load an existing file-based database into memory. Option B is also incorrect because it is not a deletion command or database management operation. It is simply a special database name recognized by SQLite to create a temporary in-memory database.

The correct answers are C and D. PEP 8 recommends that module names should be short and entirely lower-case; underscores may be used only when they improve readability. This keeps imports clean and predictable. PEP 8 also warns against using the single-character variable names l, O, or I because they can be visually confused with 1 and 0 in many fonts. Option A is incorrect because Python class names should normally use the CapWords convention, not mixedCase. Option B is incorrect because exception names are class names and should follow class naming conventions; if the exception represents an error, the name should usually end with Error.

The json.dumps() function is used to convert a Python object into a JSON string  1 . It takes Python data as its argument, such as a dictionary or a list, and returns a JSON string.

To test whether two variables refer to the same object in memory, you should use the  is  operator. The  is  operator returns  True  if the two variables point to the same object in memory, and  False  otherwise.

For example:

a = [1, 2, 3]

b = a

c = [1, 2, 3]

print(a is b) # True

print(a is c) # False

In this example,  a  and  b  refer to the same list object in memory, so  a is b  returns  True . On the other hand,  a  and  c  refer to two separate list objects with the same values, so  a is c  returns  False .

Option B is correct because it sets the font option of the button to a tuple containing the font family (‘Arial’), size (12), and style (‘italic’).

Option C is correct because it sets the font option of the button to a string containing the font family (‘Arial’), size (12), and style (‘italic’) separated by spaces.

A. The sqlite3 module in python provides an interface compliant to the DB-API 2.0. Thus, it follows a standard performance metric that allows for consistency in database programming with python.

B. The special name 'memory' is used to create a database in RAM using the sqlite3 module. Thus, when you use it as the name of the database file while opening a connection, it creates a temporary database that exists only in memory.

The correct answer is C. The code creates an XML root element named data and then adds two child elements named car. Each car element receives a brand attribute, one with the value Audi and the other with the value Volkswagen. The statement tree.write('cars.xml', 'UTF-8', True) writes the XML document using UTF-8 encoding and explicitly enables the XML declaration through the third argument. Because the XML declaration is enabled, the output begins with < ?xml version='1.0' encoding='UTF-8'? > . The generated XML body then contains the data element with two self-closing car child elements. Options without the encoding declaration are therefore incomplete.

The correct answer is A because { 1 } is not valid JSON syntax. In JSON, curly braces represent an object, but an object must contain name-value pairs. Property names must be strings enclosed in double quotation marks, followed by a colon and a value, such as {"id": 1}. The expression { 1 } contains a numeric value inside braces without a property name or colon, so it cannot be parsed as a JSON object. It is also not an array, because JSON arrays use square brackets, such as [1]. It is not an integer either, because the braces change the syntax. Therefore, this JSON string is erroneous.

The correct answer is  C. Excalibur is the value passed to an instance variable . In the given code snippet,  self.name  is an instance variable of the  Sword  class. When an instance of the  Sword  class is created with  varl = Sword('Excalibur') , the value  'Excalibur'  is passed as an argument to the  __init__  method and assigned to the  name  instance variable of the  varl  object.

The code defines a class called  Sword  with an  __init__  method that takes one parameter  name . When a new instance of the  Sword  class is created with  varl = Sword('Excalibur') , the value of the  'Excalibur'  string is passed as an argument to the  __init__  method, and assigned to the  self.name  instance variable of the  varl  object.

The correct answer is B. The ConfigParser.sections() method returns a list of section names, but it does not include the special DEFAULT section. Therefore, even though config['DEFAULT'] = {} is present, DEFAULT is excluded from the printed result. The code then creates three regular sections: mysql, postgresql, and redis. Assigning config['redis'] = config['postgresql'] creates or updates a separate section named redis using the values from the postgresql section; it does not duplicate the section name postgresql in the section list. Therefore, the output contains only the normal section names: ['mysql', 'postgresql', 'redis'] .

Option A is true because PEP 8 recommends avoiding extraneous whitespace immediately inside parentheses, brackets or braces  1 .

Option C is true because PEP 8 recommends avoiding extraneous whitespace between a trailing comma and a following close parenthesis  1 .

Option A is true because PEP 8 recommends that function and variable names should be lowercase, with words separated by underscores .

Option D is true because PEP 8 recommends that constants should be written in all capital letters with words separated by underscores .

PEP 8 is the official style guide for Python code. It provides guidelines for how to write readable code that follows consistent naming conventions. The aim of PEP 8 is to improve the readability of Python code and make it easier to understand and maintain.

According to PEP 8, variable and function names should be written in all lower-case letters with words separated by underscores, as stated in A. Constants, which are variables whose value is expected to remain constant throughout the code, should be written in all upper-case letters with words separated by underscores, as stated in D.

The correct answers are C and D. PEP 8 recommends surrounding top-level function and class definitions with two blank lines. This improves readability by clearly separating major program units in a module. Inside a class, method definitions should be separated by a single blank line because methods are more closely related and need less visual separation than top-level definitions. Option A is incorrect because imports are commonly grouped into standard library imports, third-party imports, and local application imports, with blank lines separating those groups. Option B is incorrect because one blank line is insufficient for top-level functions and classes under PEP 8. These spacing rules support clean, predictable, maintainable Python code layout.

In the given code snippet, the  repeat  function is a decorator that takes an argument  num_times  specifying the number of times the decorated function should be called. The  repeat  function returns an inner function  wrapper_repeat  that takes a function  func  as an argument and returns another inner function  wrapper  that calls  func   num_times  times.

The provided code snippet represents an example of a decorator that accepts its own arguments. The  @decorator_function  syntax is used to apply the  decorator_function  to the  some_function  function. The  decorator_function  takes an argument  arg1  and defines an inner function  wrapper_function  that takes the original function  func  as its argument. The  wrapper_function  then returns the result of calling  func , along with the  arg1  argument passed to the  decorator_function .

Here is an example of how to use this decorator with  some_function :

@ decorator_function ( "argument 1" )

def some_function ():

return "Hello world"

When  some_function  is called, it will first be passed as an argument to the  decorator_function . The  decorator_function  then adds the string  "argument 1"  to the result of calling  some_function()  and returns the resulting string. In this case, the final output would be  "Hello world argument 1" .

Option B is true because the  unbind()  method is invoked from within a widget’s object  1 .

Option D is true because the  unbind()  method needs the event name as an argument  1 .

The  unbind()  method in Tkinter is used to remove a binding between an event and a function. It can be invoked from within a widget's object when a binding is no longer needed. The method requires the event name as an argument to remove the binding for that specific event. For example:

button = tk.Button(root, text="Click me")

button.bind(" < Button-1 > ", callback_function) # bind left mouse click event to callback_function

button.unbind(" < Button-1 > ") # remove the binding for the left mouse click event

The socket.gaierror exception is raised when an address-related error caused by the getaddrinfo() and getnameinfo() functions occurs. These functions are used to translate hostnames to IP addresses and vice versa, and the gaierror exception is raised if they fail to perform this translation.

The snippet raises a NameError because the variable height is referenced inside the constructor but is never defined. The __init__() method accepts only weight and sex as parameters, apart from self. When kitty = Cat(1, 'male') is executed, Python enters the constructor and evaluates self.height = height. Since there is no local variable, parameter, global variable, or built-in name called height, Python raises a NameError before the object is fully initialized. Because object construction fails, kitty.say() is never reached. The code does not print meows, and it does not raise ValueError, because the problem is not an invalid value but an undefined name.