TM254 – Block 2 Part 9: Managing data access (Offline Quiz)

Data sharing • Access control • Concurrency • Data quality • Continuity • ACID/CAP/BASE & alternatives. :contentReference[oaicite:1]{index=1}

Settings
Question bank: 0
If it opens blank: check it isn’t saved as 9.html.txt.
Ready
What this quiz covers
  • Controlled sharing + least privilege + documenting who/what/why (external schema).
  • SQL access control: users, roles, privileges, GRANT/REVOKE, schema USAGE, search_path.
  • Views for controlled access (including hiding columns + showing processed/aggregated data).
  • Concurrency: lost update, transactions, locking, deadlock; pessimistic vs optimistic.
  • Data quality: accurate/complete/timely/relevant/understandable/trustworthy.
  • Continuity: full/differential/incremental backups, transaction logs, recovery idea; fault tolerance.
  • Alternatives: ACID, CAP, BASE, NoSQL, OLAP/data warehouse, document/semantic processing.