Database4

What does the fetchall() method return in Python’s database interaction?

• The number of rows affected by the last SQL command

• A list of tuples representing each row of the result set

• The first row of the result set

• The last row of the result set

Which method is used to close the cursor in Python’s database interaction?

• cursor_close()

• close()

• destroy()

• cursor_destroy()

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

• To execute a transaction

• To fetch results from the database

• To undo changes made since the last commit()

• To close the database connection

Which method is used to execute multiple SQL commands in a single call in sqlite3?

• execmany()

• executescript()

• execute_many()

• execute_script()

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

• To fetch a specific number of rows from the result set

• To fetch all rows from the result set

• To fetch the first row of the result set

• To fetch the last row of the result set

Which method is used to create a new table in a database using sqlite3 in Python?

• create_table()

• execute()

• make_table()

• table_create()

Which SQL command is used to update existing records in a database table?

• UPDATE

• INSERT INTO

• SELECT

• DELETE FROM