Lesson 4.10.4.1

4.10.4.1 Structured Query Language (SQL) 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.4.1, Structured Query Language (SQL): 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. Which SQL command is used to retrieve data from a database table?

    • EXTRACT
    • GET
    • FETCH
    • SELECT

  2. Which SQL clause is used to insert new records into a database table?

    • APPEND TO
    • INSERT INTO
    • ADD ROW
    • CREATE ROW

  3. Which SQL command is used to modify existing data records within a table?

    • UPDATE
    • ALTER
    • CHANGE
    • MODIFY

  4. Which SQL clause filters records to restrict which rows are affected or returned?

    • LIMIT
    • FILTER
    • HAVING
    • WHERE

  5. Which attribute is returned by the query 'SELECT Name FROM Customer WHERE City = 'York''?

    • Name
    • City
    • York
    • Customer

  6. Which SQL command is used to define a new table structure in a database?

    • NEW TABLE
    • CREATE TABLE
    • DEFINE TABLE
    • MAKE TABLE

  7. Which SQL keyword specifies the field values being added in an INSERT command?

    • SET
    • DATA
    • FIELDS
    • VALUES

  8. Which SQL command is used to remove records from a database table?

    • REMOVE FROM
    • DROP TABLE
    • ERASE FROM
    • DELETE FROM

  9. Which SQL keyword specifies the new field values to apply in an UPDATE statement?

    • SET
    • VALUES
    • TO
    • INTO

  10. Which SQL clause combines records from two tables based on a related column?

    • LINK TABLES
    • MERGE WITH
    • UNION ALL
    • INNER JOIN

  11. Which SQL clause arranges identical data into groups for aggregate functions like COUNT?

    • ALIGN BY
    • GROUP BY
    • SORT BY
    • ORDER BY

  12. Which SQL keyword sorts query results from highest value to lowest value?

    • DOWN
    • HIGH
    • DESC
    • ASC

  13. Which SQL command completely removes a table and its structure from a database?

    • DROP TABLE
    • REMOVE TABLE
    • DELETE FROM
    • TRUNCATE TABLE

  14. Which SQL keyword is used to combine rows from two or more tables based on a related column?

    • MERGE
    • UNION
    • JOIN
    • GROUP BY

  15. Which SQL clause is used to sort the result set of a query?

    • GROUP BY
    • SORT BY
    • ORDER BY
    • ALIGN BY

  16. Which SQL join type includes all records from the left table even if there are no matches?

    • CROSS JOIN
    • LEFT JOIN
    • INNER JOIN
    • RIGHT JOIN

  17. Which SQL keyword links a foreign key in one table to a primary key in another?

    • LINKS TO
    • CONNECTS
    • FOREIGN KEY
    • REFERENCES

  18. What is the main purpose of the DISTINCT keyword in a SQL SELECT statement?

    • Remove duplicate rows
    • Sort output values
    • Filter null values
    • Group related records

  19. What happens if an UPDATE statement is executed without a WHERE clause?

    • No records change
    • All records change
    • First record changes
    • Query throws error

  20. Which SQL condition correctly checks whether a column contains no value?

    • = NULL
    • IS EMPTY
    • = ''
    • IS NULL

All AQA Computer Science quizzes