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

Questions 6–10

1. 6foundation · easy

   Which method is used to close an SQLite database connection?

   • Aconn.release()
   • Bconn.disconnect()
   • Cconn.close()
   • Dconn.end()
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which method on a connection object makes all changes since the last commit permanent?

   • Aconn.save()
   • Bconn.commit()
   • Cconn.flush()
   • Dconn.close()
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   Which method is used to execute a single SQL statement on a cursor?

   • Acursor.run()
   • Bcursor.execute()
   • Ccursor.query()
   • Dcursor.exec()
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which clause is used to filter rows in a SELECT statement?

   • AGROUP BY
   • BWHERE
   • CORDER BY
   • DHAVING
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   If you call fetchall() after already calling fetchone(), what will it return?

   • AAll rows including the one already fetched
   • BThe same row returned by fetchone()
   • CAll remaining rows except the one already fetched
   • DAn empty list
   Reveal Solution Discussion Select an answer first