placeholder image to represent content

Database Backup and Recovery

Quiz by Rosanne Birney

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
9 questions
Show answers
  • Q1
    Which of the following is NOT a type of backup?
    Restoration
    Offline
    Physical
    Logical
    60s
  • Q2
    True or false: A logical backup involves copying the files that make up the database and its data.
    True
    False
    60s
  • Q3
    The mysqldump function can be used to perform which type of backup?
    Physical
    Offline
    Online
    Logical
    60s
  • Q4
    Sell-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 backups
    Offline backups
    60s
  • Q5
    True or false: a transaction is an individual action carried out on the database.
    True
    False
    60s
  • Q6
    What does the acronym ACID stand for in relation to database transactions?
    Atomicity, Correlation, Impedance, Duration
    Availability, Consistency, Immediacy, Durability
    Atomicity, Consistency, Isolation, Durability
    Availability, Coherence, Isolation, Durability
    60s
  • Q7
    A 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?
    Consistency
    Atomicity
    Durability
    Isolation
    60s
  • Q8
    Concurrent transactions, and the changes made within them, should not be visible to one another until completed. Which rule of ACID transactions is this?
    Duration
    Isolation
    Consistency
    Atomicity
    60s
  • Q9
    Examine 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?
    Question Image
    T4, T5
    T2, T3
    T1, T6
    All of them
    60s

Teachers give this quiz to your class