Which of the following is not the module provided by Python to connect with MySQL?

Which of the following commands is used to stop the connection between Python and Mysql?

Arrange the below steps in order to communicate with the database?

1. Get connection object using the connect()

2. Use the execute() function by passing query

3. Call the cursor() method

What does ‘R’ mean in CRUD?

What does the below code do?

import mysql.connector

db=mysql.connector.connect(user=”root”,passwd=”1234″,host=”localhost”) 

my_cursor=db.cursor()

my_cursor.execute(“CREATE DATABASE db”)

db=mysql.connector.connect(user=”root”,passwd=”1234″,host=”localhost”,database=’d_b’) 

my_cursor=db.cursor()

query=”CREATE TABLE food” 

my_cursor.execute(query)

Which of the following is the correct code to add a column named ‘clmn’ to the table ‘tab’ that is a primary key?

What is the output of the below code, the database db exists in the server?

import mysql.connector

db=mysql.connector.connect(user=”root”,passwd=”1234″,host=”localhost”,database=’db’) 

my_cursor=db.cursor()

query=”CREATE TABLE tb(cl1 INT(10),cl2 VARCHAR(255), cl3 INT(10))” 

my_cursor.execute(query) 

my_cursor.execute(“INSERT INTO tb(cl1,cl2,cl3) VALUES(1,’a’,6)”)

db.commit()

print(my_cursor.rowcount)

Which of the following commands is used to get all the tables in the database?

What does the below command do, if the table name tb and it has 5 records?

query = “SELECT * FROM tb”

my_cursor.execute(query)

print(my_cursor.fetchone())

Which of the following command inserts multiple records at once into the table tb containing 3 columns cl1,cl2,cl3?

What is the following code select from table tb containing 3 columns cl1,cl2,cl3?

query = “SELECT cl1 FROM tb WHERE cl1>1”

my_cursor.execute(query)

Which of the following is the correct way to delete all the information from the table tb?

Which of the following is the correct command to change all the value of the cl3 to 1 from table tb containing 3 columns cl1,cl2,cl3?

What is the function of the below code from table tb containing 3 columns cl1,cl2,cl3?

query = “DELETE FROM tb WHERE cl1 = 1”

my_cursor.execute(query)

Which of the following commands is used to delete a table?