Mastering SQL with Python and MySQL - B

What library is commonly used to connect Python to MySQL?

• MySQLdb

• mysqlclient

• PyMySQL

• mysql-connector-python

How do you establish a connection to a MySQL database in Python?

• import sqlite3; conn = sqlite3.connect('dbname')

• import mysql.connector; conn = mysql.connector.connect(host='hostname', user='username', password='password', database='dbname')

• import mysql; conn = mysql.connect('hostname', 'username', 'password')

• import pymysql; conn = pymysql.connect(host='hostname', user='username', password='password')

What is the purpose of the cursor object in Python MySQL operations?

• The cursor object is used to create new databases.

• The cursor object manages user permissions in MySQL.

• The cursor object is responsible for database backups.

• The cursor object facilitates executing SQL commands and fetching data from a MySQL database.

Which method is used to execute a SQL query in Python?

• execute() method of a cursor object

• submit() method of a SQL handler

• query() method of a database object

• run() method of a database connection

What does CRUD stand for in database operations?

• Create, Read, Update, Delete

• Create, Read, Archive, Delete

• Create, Retrieve, Update, Remove

• Construct, Read, Update, Destroy

How do you create a new table in MySQL using Python?

• Connect to the database using a CSV file.

• Execute an INSERT statement to add a new table.

• Use the MySQL Connector library to connect to the database and execute a CREATE TABLE SQL statement.

• Use the SQLite library to create a new database.

What SQL command is used to retrieve data from a database?

• UPDATE

• SELECT

• DELETE

• INSERT

How can you update a record in a MySQL table using Python?

• Use the MySQL Connector library to execute an 'UPDATE' SQL statement.

• Use the MySQL Connector library to execute a 'SELECT' SQL statement.

• Use the SQLite library to execute a 'DELETE' SQL statement.

• Update records using a CSV file instead of SQL commands.

What is the syntax for deleting a record in MySQL?

• DROP FROM table_name WHERE condition;

• REMOVE FROM table_name WHERE condition;

• DELETE table_name WHERE condition;

• DELETE FROM table_name WHERE condition;

How do you fetch all rows from a SELECT query in Python?

• Use cursor.fetchall() after executing the SELECT query.

• Use cursor.get_all() to retrieve all rows.

• Execute the query without a cursor.

• Use cursor.fetchone() to get a single row.