Skip to content
#1. _________ is an interface for connecting to a MySQL database server from python.
#2. Once a database connection is established, we are ready to ______ tables or records into the database tables using execute method of the created cursor.
#3. _______ is required when you want to create your records into a database table.
#4. _______ operation in any database means to fetch some useful information from the database.
#5. _________ fetches the next row of a query result set.
#6. _________ fetches all the rows in a result set.
#7. This is a read only attribute and returns the number of rows that were affected by an execute() method.
#8. ________ operation on any database means to update one or more records.
#9. ________ operation is required when we want to delete some records from our database.
#10. Either a transaction completes or nothing happens at all.
#11. A transaction must start in a consistent state and leave the system in a consistent area.
#12. Intermediate results of a transaction are not visible outside the current transaction.
#13. Once a transaction was committed, the effects are persistent, even after a system failure.
#14. _______ is the operation, which gives a green signal to database to finalize the changes, and after this operation, no change can be reverted back.
#15. _______ are mechanism that ensures data consistency.
#16. If you are not satisfied with one or more of the changes and you want to revert back those changes completely, then use __________ method.
#17. To disconnect database connection, use ________ method.
#18. Used for non-fatal issues.
#19. Base class for error means
#20. ________ used for errors in the database module, not the database itself.
#21. _______ used for errors in the database.
#22. Subclass of Databaseerror that refers to errors in the data.
#23. Subclass of databaseerror for situations that would damage the relational integrity, such as uniqueness constraints or foreign keys.
#24. Subclass of databaseerror that refers to errors such as the loss of a connection to the database.
#25. Subclass of DatabaseError that refers to errors such as a bad table name and other things that can safely be blamed on you.
