Question 1

Which design pattern is used to represent part-whole hierarchies of objects?

Options :

A : Observer

B : Composite

C : Proxy

D : Adapter

Answer: B

Question 2

How can you limit the number of rows returned in a MySQL query using Python?

Options :

A : Using the execute() method with a LIMIT parameter

B : Using the fetchmany() method and specifying the number of rows

C : Using the LIMIT clause in the SQL query

D : Using the fetchone() method and specifying the number of rows

Answer: C

Question 3

What library is commonly used to access MySQL databases in Python?

Options :

A : PySQL

B : MySQLdb

C : PySQLdb

D : MySQLConnector

Answer: B

Question 4

Which design pattern is used to provide a surrogate or placeholder for another object to control its access?

Options :

A : Adapter Pattern

B : Observer Pattern

C : Proxy Pattern

D : Facade Pattern

Answer: C

Question 5

Which of the following is the correct syntax to establish a connection to a MySQL database in Python?

Options :

A : conn = mysql.connect(host='localhost', user='root', password='password', database='mydb')

B : conn = mysql.connect("localhost", "root", "password", "mydb")

C :

conn = mysql.connect("localhost", username="root", password="password", database="mydb")

D : conn = mysql.connect('localhost', 'root', 'password', 'mydb')

Answer: D

Free PCPP2 Mock Exam – Practice Online Confidently