Interface of python with SQL Quiz Class 12 CBSE Python

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

Connects Python to the internet

Establishes a connection to an SQL database

Connects Python modules

Connects Python to external APIs

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

create_cursor()

make_cursor()

cursor()

generate_cursor()

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

Executes SQL queries

Defines a new table

Imports data into Python

Initiates a database connection

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

commit()

apply()

save()

finalize()

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

fetchrow()

fetchnext()

fetchone()

fetchrowset()

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

insert_query()

execute_insert()

execute(“INSERT …”)

add_record()

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

Fetches the first row of the result set

Fetches all the rows of the result set as a list of tuples

Fetches the last row of the result set

Fetches a specific row based on a condition

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

rowcount()

get_rowcount()

rows_affected()

query_rows()

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

Fetches the first row of the result set

Fetches all the rows of the result set

Fetches a specific row based on a condition

Fetches the last row of the result set

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

cursor_update()

execute(“UPDATE …”)

update_record()

modify_query()

Interface of python with SQL Quiz Class 12

Interface of python with SQL Quiz Class 12

Related Post

CSV File Quiz Class 12

Binary File Quiz Class 12

Text File Quiz Class 12

CBSE Python