Interface of python with SQL Quiz Class 12

Here’s a 15-question quiz based on the topic “Interface of Python with an SQL Database: Connecting SQL with Python, Performing Insert, Update, Delete Queries Using Cursor, Display Data by Using connect(), cursor(), execute(), commit(), fetchone(), fetchall(), rowcount, Creating Database Connectivity Applications, Use of %s Format Specifier or format() to Perform Queries”

1. What does the connect() function do when working with Python and SQL databases?

 
 
 
 

2. Which function is used to create a cursor object when interacting with an SQL database in Python?

 
 
 
 

3. In Python, what is the purpose of the execute() method when working with an SQL database?

 
 
 
 

4. How is data committed to an SQL database using Python?

 
 
 
 

5. Which method retrieves the next row of a query result set in Python?

 
 
 
 

6. How do you perform an insert query using a cursor in Python?

 
 
 
 

7. What does the fetchall() method do in Python when working with an SQL database?

 
 
 
 

8. How can you check the number of rows affected by the last query in Python?

 
 
 
 

9. What is the purpose of the fetchone() method in Python when working with an SQL database?

 
 
 
 

10. How do you perform an update query using a cursor in Python?

 
 
 
 

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved
error: Content is protected !!