SQLite and Python Quiz

What is SQLite most commonly used for?

• Small-scale data storage solutions

• Cloud-based data management

• Large-scale enterprise databases

• Real-time data processing

What is the first step in using SQLite with Python?

• Execute a query

• Insert data

• Create a table

• Import the SQLite3 module

What happens if you try to connect to a non-existent database file in SQLite?

• The connection is refused

• The program crashes

• A new database file is created

• An error is thrown

Which method is used to insert multiple rows of data in SQLite?

• execute_batch

• execute_script

• execute_many

• execute

What is the correct way to commit a transaction in SQLite?

• Call commit on the table

• Call commit on the database

• Call commit on the connection

• Call commit on the cursor

Which SQLite data type corresponds to Python's 'int' type?

• REAL

• TEXT

• INTEGER

• BLOB

Why is it important to use placeholders in SQL queries?

• To simplify query syntax

• To reduce database size

• To improve query performance

• To prevent SQL injection attacks

What is the purpose of the 'execute_script' method in SQLite?

• To create a new database

• To delete a table

• To run a SQL script as a string

• To execute a single SQL query

What is a key benefit of using SQLite for data storage?

• It supports real-time analytics

• It requires no setup

• It is free and open-source

• It is cloud-based

What should you do after executing queries in SQLite?

• Leave the connection open

• Close the connection

• Restart the database

• Re-run the queries