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