Exam PCPP-32-101 topic 1 question 42 discussion

B is wrong, it's ':memory:'. Hence, A and D are the right ones.

D. The fetchall method returns an empty list when no rows are available. This is incorrect. The fetchall() method does indeed return an empty list [] when no rows are available, but the statement is phrased ambiguously. Since no rows are available, fetchall() returns an empty list rather than None, which makes the statement technically true, but it is somewhat misleading since the key point is that the list will be empty, not that no rows are available.

Seems A,B,D are correct. The standard Python library has a module called sqlite3, providing an interface compliant with the DB-API 2.0 specification. https://edube.org/learn/pcpp1-5/working-with-an-sqlite-database It's also possible to use a special name, :memory:, which creates a database in RAM: conn = sqlite3.connect(':memory:') Other 2 ways to create database: conn = sqlite3.connect('hello.db') conn = sqlite3.connect('C:\sqlite\hello.db') https://edube.org/learn/pcpp1-5/creating-a-database The fetchall method returns an empty list when no rows are available. https://edube.org/learn/pcpp1-5/reading-data-2