PCPP-32-101 5.1 Database Programming in Python PCPP-32-1 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A long-running script opens a SQLite connection, performs many read-only SELECT queries, and then exits. The developer notices that the database file remains locked even after the script finishes. What is the most likely cause and the best fix?

   • AThe script used ':memory:' instead of a file; switch to a file-based database.
   • BThe script did not call conn.commit(); add conn.commit() after each SELECT.
   • CThe connection was not closed; add conn.close() at the end of the script.
   • DThe cursor was not closed; add cursor.close() after each query.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   What argument should you pass to sqlite3.connect() to create an in-memory database?

   • A':memory:'
   • BNone
   • C'temp.db'
   • D'' (empty string)
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which SQL statement is used to create a new table in a database?

   • ACREATE TABLE
   • BNEW TABLE
   • CINSERT TABLE
   • DALTER TABLE
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   Which SQL statement is used to retrieve data from a table?

   • AFETCH
   • BREAD
   • CGET
   • DSELECT
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   What does the fetchone() method return?

   • AThe next row of the result set as a tuple, or None if no more rows
   • BAll rows of the result set as a list of tuples
   • CThe first row of the result set as a list
   • DThe number of rows in the result set
   Reveal Solution Discussion Select an answer first