Database3

What is the purpose of the sqlite3 module in Python?

• To perform mathematical operations

• To interact with SQLite databases

• To generate random numbers

• To handle JSON data

Which method is used to establish a connection to a database using sqlite3 in Python?

• create_connection()

• connect()

• open_connection()

• establish_connection()

Which method is used to execute an SQL query and fetch all the results in Python’s database interaction?

• execute_query()

• fetch_all()

• execute_fetch_all()

• fetchall()

What is the purpose of the commit() method in Python’s database interaction?

• To execute a transaction

• To fetch results from the database

• To close the database connection

• To roll back changes

Answer explanation

The commit() method is used to execute a transaction and save changes to the database.

Which SQL command is used to retrieve data from a database table?

• SELECT

• UPDATE

• INSERT INTO

• DELETE FROM

What does the fetchone() method do in Python’s database interaction?

• Fetches all rows from the result set

• Fetches the next row of a query result set

• Fetches the first row of a query result set

• Fetches a specific row based on index

Which of the following methods is used to execute parameterized SQL queries in sqlite3?

• execute_query()

• execute_params()

• execute()

• execute_script()