Skip to main content

← back to the guide

CCEA A-Level Software Systems Development A2 1 Systems Approaches and Database Concepts overview quiz quiz

16questions. Pick an answer and you'll see why right away.

  1. Which systems development lifecycle stage gathers the requirements of the new system?

  2. Which stage continues for the working life of a system and can be corrective, adaptive or perfective?

  3. The waterfall model is best described as:

  4. Which approach is most suitable when requirements are unclear and likely to change?

  5. Which fact-finding technique best reveals what users actually do rather than what they say they do?

  6. In a data flow diagram, what is represented by an open-ended rectangle?

  7. A UML use case diagram primarily shows:

  8. Which UML diagram shows classes with their attributes, methods and relationships?

  9. A field that uniquely identifies each record in a table, and cannot be null, is the:

  10. Referential integrity requires that a foreign key value:

  11. A many-to-many relationship between two tables is resolved by:

  12. Removing repeating groups so that every field holds a single atomic value puts a table into:

  13. Third normal form is reached by removing:

  14. Which SQL clause filters which rows are returned by a SELECT query?

  15. What does a SQL INNER JOIN do?

  16. Which SQL statement changes the values in existing rows?