Lesson 4.10.5.1

4.10.5.1 Client server databases Quiz: AQA Computer Science, Unit 10

20 questions

Written by Revision Ninja · Last reviewed 11 October 2026

In partnership with Revision Ninja

Lesson 4.10.5.1, Client server databases: 20 multiple choice questions for the AQA Computer Science (7517), Unit 10: Fundamentals of databases, written with Revision Ninja.

Host it live on the board and students join with a game code on their own devices, or revise alone with Free Play. The answers are revealed in the game.

Host this setFree Play

The 20 questions

  1. What primary access model does a client-server database offer to multiple users?

    • Simultaneous access
    • Read-only access
    • Sequential access
    • Isolated access

  2. What main issue occurs when two concurrent database clients edit the same record simultaneously?

    • Phantom read
    • Lost update
    • Dirty read
    • Deadlock

  3. Which mechanism prevents other users from editing a database record while it is being modified?

    • Record locking
    • Database backup
    • Password protection
    • Data encryption

  4. What is the primary purpose of transaction serialisation in client-server databases?

    • Increase query speed
    • Encrypt transaction data
    • Reduce memory usage
    • Preserve data integrity

  5. Which concurrency control technique uses system time to order conflicting database operations?

    • Two-phase locking
    • Timestamp ordering
    • Commitment ordering
    • Record locking

  6. Why is concurrency control necessary in multi-user database systems?

    • Speed up searches
    • Prevent data conflicts
    • Validate user logons
    • Compress table data

  7. What does a record lock do when applied to a database row?

    • Restricts editing access
    • Encrypts row data
    • Deletes the record
    • Hides the record

  8. Two clients read balance 100. Client A writes 120, then Client B writes 70. What is the final balance?

    • 90
    • 120
    • 70
    • 100

  9. Starting from a balance of 100, what is the final balance if updates of +20 and -30 are serialised?

    • 100
    • 70
    • 120
    • 90

  10. In a database using record locking, what happens when a client requests a locked record?

    • Record deleted
    • Access granted
    • Changes saved
    • Must wait

  11. Which technique assigns read and write times to transactions to maintain chronological order in databases?

    • Commitment ordering
    • Timestamp ordering
    • Serialisation
    • Record locking

  12. Which concurrency control method orders conflicting database transactions based on when they finish committing?

    • Commitment ordering
    • Timestamp ordering
    • Serialisation
    • Record locking

  13. What term describes multiple clients accessing and editing a database simultaneously without data corruption?

    • Concurrent access
    • Serial access
    • Batch processing
    • Exclusive access

  14. What database issue occurs when two clients edit a record simultaneously and one edit is overwritten?

    • Lost update
    • Syntax error
    • Data redundancy
    • Deadlock

  15. Which mechanism is essential to prevent conflicting edits when multiple users access a database simultaneously?

    • Batch processing
    • Hashing algorithm
    • Data redundancy
    • Concurrency control

  16. What issue occurs when two database transactions are each waiting for the other to release a lock?

    • Deadlock
    • Lost update
    • Inconsistent read
    • Data redundancy

  17. Why must concurrent database access be managed by a database management system?

    • Reduce network speed
    • Increase file size
    • Preserve data integrity
    • Prevent data storage

  18. Which technique uses timestamps to reject database updates made to outdated copies of records?

    • Data hashing
    • Commitment ordering
    • Record locking
    • Timestamp ordering

  19. Which technique ensures concurrent database transactions yield results identical to running them sequentially?

    • Serialisation
    • Normalisation
    • Data duplication
    • Record locking

  20. What is the main benefit of a client-server database over separate local copies for ticket bookings?

    • Simplifies SQL syntax
    • Reduces network usage
    • Prevents double booking
    • Requires no server

All AQA Computer Science quizzes