Skip to content

Rapid Recall 1–23

Answer each in about 60 seconds without recognition cues.

  1. Define Data Storage and Operations in one sentence.
  2. Name its three goals.
  3. Name its two main activity families.
  4. Database vs instance vs schema vs node?
  5. What does database abstraction buy and cost?
  6. What lifecycle steps are named?
  7. Why is the DBA a custodian of changes?
  8. Production DBA vs Application DBA?
  9. Procedural DBA vs Development DBA?
  10. What does an NSA support?
  11. Centralized vs distributed?
  12. Federated vs non-federated?
  13. Loose vs tight federation?
  14. Three cloud database approaches?
  15. ACID letters?
  16. BASE letters?
  17. CAP letters?
  18. Disk/SAN vs in-memory?
  19. Production vs Development?
  20. Test vs Sandbox?
  21. Schema on write vs schema on read?
  22. Row vs column-oriented workload?
  23. Valid time vs transaction time?

Minimum self-check targets

You should be able to reconstruct these controlling ideas after the attempt:

  • goals = availability, integrity, transaction performance;
  • two families = Database Technology Support / Database Operations Support;
  • DB vocabulary = stored collection / running DBMS / object grouping / distributed computer;
  • roles = production reliability / application DBs / procedural logic / development-design / storage arrays;
  • architectures = one place / multiple nodes / autonomy vs central control / loose vs integrated federated schema;
  • cloud = owner-run VM / DaaS / managed hosting;
  • ACID, BASE, CAP expanded exactly;
  • environments = Build → Prove → Run, Sandbox beside the path;
  • row vs column = OLTP-like whole rows vs OLAP-like selected-column scans;
  • valid vs transaction time = real-world truth vs database-recorded truth.

Use the Guided Learning lesson tied to the miss; do not reread the entire chapter for one weak term.

← Teach-Back index · Rapid Recall 24–45 →