Data Structures
The CPU
SQL
Ethics
General Knowledge
100

What is a linear data structure where elements are added at one end and removed from the other?

What is a Queue?

100

This register holds the address of the instruction currently being executed.

What is the Current Instruction Register (CIR)?

100

The SQL keyword used to add new records to a database table.

What is INSERT?

100

The principle of ensuring that data is accurate and kept up to date.

What is Data Integrity?

100

Produced the analytical engine that Ada Lovelace worked on

Who is Charles Babbage?

200

One is fixed in size, the other is not

Explain the difference between a static and a dynamic data structure.

200

The component of the CPU responsible for directing the operation of the processor.

What is the Control Unit?

200

This SQL clause is used to sort the results of a query.

What is ORDER BY?

200

This UK law governs how personal data is collected, processed, and stored.

What is the Data Protection Act (or UK GDPR)?

200

The company co-founded by Bill Gates and Paul Allen in 1975.

What is Microsoft?

300

 An Abstract Data Type (ADT) that stores a collection of unique key-value pairs, allowing for efficient lookup.

What is a Dictionary?

300

This factor affecting CPU performance refers to the number of cycles the CPU executes per second.

What is Clock Speed?

300

A key in one table that refers to the PRIMARY KEY in another table, establishing a link between them.

What is a FOREIGN KEY?

300

The ethical dilemma concerning the balance between national security and individual privacy in the digital age.

What is Surveillance vs. Privacy?

300

This term, now commonly used, was coined by Grace Hopper after a moth was found interfering with a relay in an early computer.

What is Debugging?

400

In the context of tree traversal, this method visits the left subtree, then the root, then the right subtree.

What is In-order traversal?

400

MDR

What is the alternative name of the MBR?

400

This process involves organising the columns and tables of a relational database to reduce data redundancy and improve data integrity, typically up to Third Normal Form.

What is Normalisation?

400

RFID

Which technology might support computer based implants?

400

The name of the first electronic general-purpose digital computer, completed in 1945.

What is ENIAC (Electronic Numerical Integrator and Computer)?

500

This data structure is a collection of nodes connected by edges, used to represent relationships between objects.

What is a Graph?

500

Bidirectional

Is the data bus bidirectional or unidirectional?

500

It returns a full combination of both the left and right tables

What does a full outer join return?

500

This concept refers to the unease or opposition to the widespread use of computers and automation due to concerns about job displacement and societal impact.

What is Technophobia (or resistance to automation)?

500

This computer scientist is known as the father of the World Wide Web.

Who is Sir Tim Berners-Lee?

M
e
n
u