
Database Backup and Recovery
Quiz by Rosanne Birney
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
9 questions
Show answers
- Q1Which of the following is NOT a type of backup?RestorationOfflinePhysicalLogical60s
- Q2True or false: A logical backup involves copying the files that make up the database and its data.TrueFalse60s
- Q3The mysqldump function can be used to perform which type of backup?PhysicalOfflineOnlineLogical60s
- Q4Sell-It.com is a global e-commerce retailer; they ship to more than 50 countries. When implementing a backup strategy, which should they choose?Online backupsOffline backups60s
- Q5True or false: a transaction is an individual action carried out on the database.TrueFalse60s
- Q6What does the acronym ACID stand for in relation to database transactions?Atomicity, Correlation, Impedance, DurationAvailability, Consistency, Immediacy, DurabilityAtomicity, Consistency, Isolation, DurabilityAvailability, Coherence, Isolation, Durability60s
- Q7A transaction attempts to write the value "maybe" to an enum field where "yes" and "no" are the only allowable options. What property of ACID transactions does this violate?ConsistencyAtomicityDurabilityIsolation60s
- Q8Concurrent transactions, and the changes made within them, should not be visible to one another until completed. Which rule of ACID transactions is this?DurationIsolationConsistencyAtomicity60s
- Q9Examine the transactions in this image. Which ones should be rolled back in the event of a database failure at the point in time represented by tf?T4, T5T2, T3T1, T6All of them60s