Python — MySQL Connectivity

Which Python module is commonly used to connect Python with MySQL databases?

What is the correct method to establish a connection to a MySQL database using mysql.connector in Python?

Which of the following commands is used to create a cursor object in Python after establishing a MySQL connection?

How do you execute a SQL SELECT query using a cursor object in Python?

After executing a SELECT query, which method fetches all rows from the result set?

Which method is used to save changes made by INSERT, UPDATE, or DELETE queries in a MySQL database using Python?

What will happen if you forget to call conn.commit() after executing an INSERT query in Python MySQL connectivity?

Which parameter is NOT required while establishing a connection to MySQL in Python?

Consider the following code snippet: import mysql.connector conn = mysql.connector.connect(host='localhost', user='root', password='root123', database='school') cursor = conn.cursor() cursor.execute("INSERT INTO students (id, name) VALUES (1, 'Rahul')") What is missing here to ensure the data is saved?

Which exception should you catch to handle errors during MySQL operations in Python using mysql.connector?