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

Questions 16–20

1. 16foundation · easy

   What is the purpose of a cursor object in the sqlite3 module?

   • ATo execute SQL statements and fetch results
   • BTo store the database file path
   • CTo manage the database connection
   • DTo define the database schema
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   How do you create a cursor object from a connection named 'conn'?

   • Acursor(conn)
   • Bconn.cursor()
   • Csqlite3.cursor(conn)
   • Dconn.create_cursor()
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which function from the sqlite3 module is used to establish a connection to an SQLite database?

   • Asqlite3.initialize()
   • Bsqlite3.open()
   • Csqlite3.connect()
   • Dsqlite3.connection()
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What does the fetchall() method return?

   • AA single tuple containing all rows
   • BA generator that yields rows one by one
   • CA list of all remaining rows, each as a tuple
   • DThe number of rows in the result set
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which SQL statement is used to add a new row to a table?

   • ACREATE
   • BINSERT INTO
   • CADD ROW
   • DUPDATE
   Reveal Solution Discussion Select an answer first