[go: up one dir, main page]
Scribd
Upload
823 views5 pages

12 Worksheet-13 Database Management

The document provides information about connecting Python to MySQL and performing CRUD (create, read, update, delete) operations. It contains multiple choice questions about establishing a connection using mysql.connector, executing queries using a cursor, fetching results from the cursor, committing transactions, and troubleshooting errors. Key topics covered include using mysql.connect() to establish the connection, cursor.execute() to send queries, fetchone(), fetchmany(), fetchall() to retrieve result rows, and con.commit() to commit transactions to the database.

Uploaded by

Divyanshi Srivastava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
823 views5 pages

12 Worksheet-13 Database Management

The document provides information about connecting Python to MySQL and performing CRUD (create, read, update, delete) operations. It contains multiple choice questions about establishing a connection using mysql.connector, executing queries using a cursor, fetching results from the cursor, committing transactions, and troubleshooting errors. Key topics covered include using mysql.connect() to establish the connection, cursor.execute() to send queries, fetchone(), fetchmany(), fetchall() to retrieve result rows, and con.commit() to commit transactions to the database.

Uploaded by

Divyanshi Srivastava
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

Worksheet -13

INTERFACE PYTHON WITH MYSQL


1. Identify the name of connector to establish bridge between Python and MySQL
a. mysql.connection
b. connector
c. mysql.connect
d. mysql.connector
2. In the following connection string: Identify the elements:

connect( <<1>>____= 127.0.0.1, <<2>> =‟ root‟, <<3>> = „admin‟)


a. <<1>> = User, <<2>> = password, <<3> = host
b. <<1>> = host, <<2>> = user, <<3> = password
c. <<1>> = host, <<2>> = password, <<3> = user
d. <<1>> = IP, <<2>> = user, <<3> = password
3. Which function of connection is used to check whether connection to mysql is
successfully done or not?
import mysql.connector as msq
con = msq.connect( #Connection String ) # Assuming all parameter
required as passed

if :
print(“Connected!”)
else:
print(“ Error! Not Connected”)

a. con.connected()
b. con.isconnected()
c. con.is_connected()
d. con.is_connect()
4. Which of the following component act as a container to hold all the data returned
from the query and from there we can fetch data one at a time?
a. ResultSet
b. Cursor
c. Container
d. Table
5. Identify the correct statement to create cursor:
import mysql.connector as msq
con = msq.connect( #Connection String ) # Assuming all parameter required as
passed
mycursor = __________
a. con.cursor()
b. con.create_cursor()
c. con.open_cursor()
d. con.get_cursor()

6. What is the difference in fetchall() and fetchone()?


7. Which attribute of of cursor is used to get number of records stored in cursor
(Assuming cursor name is mycursor)?

a. mycursor.count
b. mycursor.row_count
c. mycursor.records
d. mycursor.rowcount
8. Which of the Symbols are used for passing parameterized query for execution to cursor?

a. %
b. { }
c. $
d. Both a and b
9. Which function is used to fetch n number of records from cursor?
a. fetch()
b. fetchone()
c. fetchmany()
d. fetchall()
10. Which cursor function is used to send query to connection?
a. query()
b. execute()
c. run()
d. send()

11. Consider the information stored in the table : EMP

EMPNO ENAME DEPT SALARY


1 ALEX MUSIC 60000
2 PETER ART 67000
3 JOHNY WE 55000
4 RAMBO P&HE 48000

Following python code is written to access the records of table: EMP, What will be the output

of following code:

# Assume All basic setup related to connection and cursor creation is already done

query="select * from emp"

mycursor.execute(query)

results = mycursor.fetchone()
results = mycursor.fetchone()

results = mycursor.fetchone()

d = int(results[3])

print(d*3)

a. P&HEP&HEP&HE

b. 144000

c. WEWEWE

d. 165000

12. Consider the following Python code is written to access the record of CODE passed to

function:

Complete the missing statements:

def Search(eno):

#Assume basic setup

import, connection and cursor is created

query="select * from emp where empno= ".format(eno)

mycursor.execute(query)

results = mycursor. print(results)

a. { } and fetchone()
b. fetchone() and { }
c. %s and fetchone()
d. %eno and fetchone()
13. Consider the following Python code for updating the records:
def Update(eno):
#Assume basic setup import,
connection(con) and cursor(mycursor) is created
query="update emp set salary=90000 where empno=” + str(eno)
mycursor.execute(query)

Code is running but the record in actual database is not updating, what could be the possible
reason?
a. save() function is missing
b. con.save() function is missing
c. con.commit() function is missing
d. commit() function is missing

14. Consider the following python code to display all records from table: EMP

def showAll():

#Assume basic setup import, connection(con) and cursor(mycursor) is created

query="select * from emp"

mycursor.execute(query)

results = mycursor.fetchall()

for results in row:

print(results)

But query is giving error, What could be the possible reason?

a. fetchmany() should be used in place of fetchall()


b. fetchone() should be used in place of fetchone()
c. print(row) should be used in place of print(results)
d. loop and print function is wrong, for row in results: and print(row) should be used

15. Guess the output

You might also like