WJEC Eduqas A Level Computer Science

C2 Section 4: Organisation and Structure of Data: revision quiz and key terms

Free practice for C2 Section 4: Organisation and Structure of Data in WJEC Eduqas A Level Computer Science. It covers: full topic test for C2 Section 4: Organisation and Structure of Data. Try the questions, then check the key terms.

Try 5 free questions

No sign-in needed. Tap an answer to check it.

Question 1 · Multiple choice

Which SQL keyword is used to retrieve data from a table?

Question 2 · True or false?

Big Data refers to extremely large, complex data sets difficult to process traditionally.

Question 3 · Multiple choice

What is a foreign key?

Question 4 · True or false?

Normalisation increases data redundancy by storing the same data in several tables.

Question 5 · Multiple choice

Which file organisation stores records in key order and allows them to be accessed directly using an index?

In RADevo, this topic has fill-in-the-blank, matching, multiple-choice and true or false activities, and every question you get wrong comes back in Revise today until you've learnt it.

Key terms for C2 Section 4: Organisation and Structure of Data

Data dictionary: Records details about data, such as field names, types and constraints.
Data redundancy: The unnecessary duplication of the same data within a database.
Distributed database: A database whose data is stored across several computers or sites but appears to users as one database.
Foreign key: A field in one table that refers to the primary key of another table.
Hashing algorithm: Calculates a storage location for a record directly from its key value.
Indexed sequential file: A file stored in key order with an index so records can be accessed both sequentially and directly.
Normalisation: Organising a relational database into tables to reduce data redundancy and improve integrity.
Query language: Allows a user to retrieve specific information from a database.

What C2 Section 4: Organisation and Structure of Data covers

In RADevo this topic has a full topic test and a focused quiz for each part:

C2 Section 4: Big Data and Distributed Systems
C2 Section 4: Database Normalisation
C2 Section 4: File Design and Organisation
C2 Section 4: SQL and DBMS

Teaching WJEC Eduqas A Level Computer Science?

Set this topic as homework in two clicks, see who has done it and which questions your class got wrong, and start every lesson with a Do Now built from their mistakes.

Start a free 2-week trial

Revising for this?

If your school uses RADevo, sign in to do the full quizzes and keep your progress. If it doesn't, show this page to your Computing teacher.