Take this Exam: A-Level Computer Science: Systems, Data and Networks | Zestly

Question 1

Given a table 'Students' (StudentID, Name, TutorID) and 'Tutors' (TutorID, TutorName), what is the result of: SELECT Name FROM Students JOIN Tutors ON Students.TutorID = Tutors.TutorID WHERE TutorName = 'Dr Smith'?

Accepted Answer

Names of students taught by Dr Smith

Answer

All student names

Answer

Names of all tutors

Answer

The TutorID of Dr Smith

Question 2

In the TCP/IP stack, which layer is responsible for routing packets across different networks?

Accepted Answer

Internet Layer

Answer

Application Layer

Answer

Transport Layer

Answer

Link Layer

Question 3

A company uses asymmetric encryption to send a secure message. Which key is used to encrypt the message to ensure only the recipient can read it?

Accepted Answer

The recipient's public key

Answer

The sender's private key

Answer

The recipient's private key

Answer

The sender's public key

Question 4

Under the Data Protection Act, what is the primary responsibility of a 'Data Controller'?

Answer

To physically secure the server hardware

Answer

To write the software code for the database

Answer

To provide the internet connection

Answer

To determine the purposes and means of processing personal data

Question 5

An operating system uses paging to manage memory. What is the main purpose of a page table?

Answer

To store the operating system kernel

Answer

To map logical memory addresses to physical memory addresses

Answer

To schedule processes for the CPU

Answer

To manage the hard drive file system