Python ↔ SQL Connectivity — Chapter Test

Answer all 5 questions, then submit. You need 60% to pass. Log in to save progress.

Question 1

Which module connects Python to a MySQL database?

Asqlite3.connector

Bmysql.connector

Cpython.sql

Ddb.mysql

Question 2

What object is used to send SQL queries and read results?

AThe connection

BThe cursor

CThe commit

DThe fetch

Question 3

Which method returns ALL remaining rows as a list of tuples?

Afetchone()

Bfetchall()

Crowcount

Dexecute()

Question 4

After an INSERT from Python, what must you call to save it permanently?

Afetchall()

Bclose()

Ccommit()

Dexecute()

Question 5

Which of these does NOT need a commit()?

AINSERT

BUPDATE

CDELETE

DSELECT