CAF-3 DSR · Chapter 6

Chapter 6 MCQs: Database Normalization & Data Warehousing

Chapter 6 covers database normalisation (1NF, 2NF, 3NF) and data warehousing, including OLTP versus analytical systems, the ETL process and data marts.

What Chapter 6 covers

  • Why normalisation is needed and update anomalies
  • First, second and third normal form
  • Data warehousing concepts
  • Online Transaction Processing (OLTP)
  • Extract, Transform and Load (ETL)
  • Data marts

All free. Start straight away with 100 MCQs from any chapters; all 60 Chapter 6 questions unlock with a quick, free access request.

Need to revise first? Chapter 6 is explained in plain language, with exam tips and worked scenarios, in the free CAF-3 DSR study guide (PDF). More chapters, mock exams and AI marking: CAF-3 DSR Exam Prep.

Free study resource. Not affiliated with, endorsed by or produced by ICAP.

Certifications of Muhammad Aamir

Mirak X | mirakx.com
Free books
CISA Study GuideFree PDF · 352 pages CISA Video Course ↗Free full lessons on YouTube CAF-3 DSR Study GuideFree PDF · 457 pages CAF-3 DSR Exam PrepMCQs, mocks, AI marking CertPrepX ↗CISA practice & mock exams