Mastering SQLite3 with Python

What is the command to create a new SQLite database in Python?

• `sqlite3.connect('database_name')`

• `sqlite3.create('database_name')`

• `sqlite3.new('database_name')`

• `sqlite3.start('database_name')`

Which SQL statement is used to create a new table in a database?

• `INSERT TABLE`

• `CREATE TABLE`

• `NEW TABLE`

• `ADD TABLE`

What is the purpose of a foreign key in a database?

• To uniquely identify each row in a table

• To establish a relationship between two tables

• To store large amounts of text

• To speed up query execution

Which of the following is a type of SQL join?

• INNER JOIN

• OUTER JOIN

• LEFT JOIN

• All of the above

How do you execute an SQL command in Python using SQLite?

• `cursor.run()`

• `cursor.execute()`

• `cursor.query()`

• `cursor.command()`

What is the result of a LEFT JOIN operation?

• Only the rows that have matching values in both tables

• All rows from the left table, and the matched rows from the right table

• All rows from the right table, and the matched rows from the left table

• All rows from both tables

Which Python library is used to work with SQLite databases?

• `sqlalchemy`

• `pandas`

• `sqlite3`

• `numpy`

What is the command to terminate a connection to an SQLite database in Python?

• `connection.stop()`

• `connection.close()`

• `connection.end()`

• `connection.terminate()`

Which SQL clause is used to filter records?

• `WHERE`

• `FILTER`

• `SELECT`

• `ORDER BY`

What is the default data type for a primary key in SQLite?

• TEXT

• INTEGER

• REAL

• BLOB