Learn Extracted exam questions A-Level Computer Science 9618 Computer Science November 2025 Question Paper 11
9618 Computer Science November 2025 Question Paper 11
Source PDF on the left, extracted YAML on the right. Compare numbering, marks, options and text.
Convert the binary number into hexadecimal.
101100111010 \hrulefill
Convert the denary number into Binary Coded Decimal (BCD).
108 \hrulefill
Convert the 12-bit two’s complement binary integer into denary.
Show your working.
111110111100
Denary value \hrulefill
The following binary addition is performed using 8-bit registers.
Complete the calculation using binary addition.
Name and describe the error that can occur when binary addition is performed.
A relational database, \texttt{WORKEXPERIENCE}, stores data about students and the companies where they complete work experience.
Students can complete multiple work experience placements but can only complete one placement at a time.
Students can complete more than one placement at the same company.
Part of the database is shown:
\texttt{STUDENT(StudentID, FirstName, TelephoneNumber, UniversityName)}
\texttt{PLACEMENT(PlacementID, StudentID, CompanyID, StartDate, EndDate, Complete)}
\texttt{COMPANY(CompanyID, CompanyName, MaxStudentsPerPlacement)}
Complete the entity-relationship (E-R) diagram for the database \texttt{WORKEXPERIENCE}.
Explain why the database \texttt{WORKEXPERIENCE} is in Third Normal Form (3NF).
Some example data from the \texttt{PLACEMENT} table is shown:
\begin{tabular}{|l|l|l|l|l|l|} \hline \textbf{PlacementID} & \textbf{StudentID} & \textbf{CompanyID} & \textbf{StartDate} & \textbf{EndDate} & \textbf{Complete} \ \hline PC001 & LDEA01 & MSCM & 01/01/2023 & 12/07/2023 & TRUE \ \hline PC002 & LDEA01 & MSCM & 01/04/2024 & 08/05/2024 & FALSE \ \hline PC003 & ALAU02 & NEAM & 09/03/2020 & 10/03/2021 & FALSE \ \hline PC004 & LOLI75 & GOUZ & 07/06/2018 & 11/09/2018 & TRUE \ \hline \end{tabular}
Write a Structured Query Language (SQL) script to delete all placements that have been completed.
Write an SQL script to return the total number of placements completed by the student with ID LDEA01 at the company with ID NEAM. The total should be given an appropriate name.
The database tables are repeated here:
\texttt{STUDENT}(\underline{\texttt{StudentID}}, \texttt{FirstName}, \texttt{TelephoneNumber}, \texttt{UniversityName})
\texttt{PLACEMENT}(\underline{\texttt{PlacementID}}, \texttt{StudentID}, \texttt{CompanyID}, \texttt{StartDate}, \texttt{EndDate}, \texttt{Complete})
\texttt{COMPANY}(\underline{\texttt{CompanyID}}, \texttt{CompanyName}, \texttt{MaxStudentsPerPlacement})
Explain what is meant by referential integrity, and how it applies to this database.
Draw a logic circuit for the logic expression:
Write the logic expression for the following truth table.
\begin{tabular}{|c|c|c|c|} \hline \textbf{R} & \textbf{S} & \textbf{T} & \textbf{Q} \ \hline 0 & 0 & 0 & 0 \ \hline 0 & 0 & 1 & 1 \ \hline 0 & 1 & 0 & 0 \ \hline 0 & 1 & 1 & 0 \ \hline 1 & 0 & 0 & 0 \ \hline 1 & 0 & 1 & 0 \ \hline 1 & 1 & 0 & 1 \ \hline 1 & 1 & 1 & 0 \ \hline \end{tabular}
Q = \hrulefill
The table shows part of the instruction set for a processor. The processor has one register, the Accumulator (ACC).
\begin{tabular}{|c|l|l|} \hline \multicolumn{2}{|c|}{\textbf{Instruction}} & \multicolumn{1}{c|}{\textbf{Explanation}} \ \cline{1-2} \textbf{Opcode} & \textbf{Operand} & \ \hline AND & #n / Bn / &n & Bitwise AND operation of the contents of the ACC with the operand \ \hline AND &
& Bitwise AND operation of the contents of the ACC with the contents of \ \hline XOR & #n / Bn / &n & Bitwise XOR operation of the contents of the ACC with the operand \ \hline XOR & & Bitwise XOR operation of the contents of the ACC with the contents of \ \hline OR & #n / Bn / &n & Bitwise OR operation of the contents of the ACC with the operand \ \hline OR & & Bitwise OR operation of the contents of the ACC with the contents of \ \hline LSL & #n & Bits in ACC are shifted logically n places to the left. Zeros are introduced on the right-hand end. \ \hline LSR & #n & Bits in ACC are shifted logically n places to the right. Zeros are introduced on the left-hand end. \ \hline \end{tabular}\begin{itemize} \item
can be an absolute or symbolic address \item # denotes a denary number, e.g. #127 \item B denotes a binary number, e.g. B10010001 \item & denotes a hexadecimal number, e.g. &4A \end{itemize}The ACC currently contains the following positive binary integer:
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 0 & 0 & 0 & 1 & 1 & 1 & 1 & 0 \ \hline \end{tabular}
Write a bit manipulation instruction that uses a binary shift to change the contents of the ACC to:
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 0 & 1 & 1 & 1 & 1 & 0 & 0 & 0 \ \hline \end{tabular}
Instruction \hrulefill \hfill
The ACC currently contains the following positive binary integer:
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 1 & 1 & 1 & 0 & 0 & 0 & 1 & 1 \ \hline \end{tabular}
Write the contents of the ACC after the instruction \texttt{XOR &12} is carried out.
\framebox{$\square\,\square\,\square\,\square\,\square\,\square\,\square\,\square$}
The ACC currently contains the following positive binary integer:
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 1 & 1 & 1 & 0 & 0 & 0 & 1 & 1 \ \hline \end{tabular}
Write the contents of the ACC after the instruction \texttt{AND #63} is carried out.
\framebox{$\square\,\square\,\square\,\square\,\square\,\square\,\square\,\square$}
The ACC currently contains the following positive binary integer:
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 1 & 1 & 1 & 0 & 0 & 0 & 1 & 1 \ \hline \end{tabular}
The current contents of memory are:
\begin{tabular}{cc} \textbf{Address} & \textbf{Data} \ 98 & 00100100 \ 99 & 00110001 \ 100 & 00110011 \ 101 & 10100011 \ 102 & 10101100 \end{tabular}
Write the contents of the ACC after the instruction \texttt{OR 100} is carried out.
\framebox{$\square\,\square\,\square\,\square\,\square\,\square\,\square\,\square$}
The Operating System (OS) is responsible for hardware and security management in a computer system.
State \textbf{two} tasks that are performed by hardware management.
- \hrulefill
- \hrulefill
State \textbf{two} tasks that are performed by security management.
- \hrulefill
- \hrulefill
Describe \textbf{one} benefit of using library routines when developing software.
Describe \textbf{one} drawback of using library routines when developing software.
Identify \textbf{two} presentation features found in a typical Integrated Development Environment (IDE).
- \hrulefill
- \hrulefill
The processor uses several registers, including the Accumulator (ACC) and the Current Instruction Register (CIR).
Complete the table by describing the role of each register.
\begin{tabular}{|p{3cm}|p{10cm}|} \hline \textbf{Register} & \textbf{Role} \ \hline ACC & \ & \ \hline CIR & \ & \ \hline \end{tabular}
Increasing the number of cores in a processor can affect the performance of a computer.
Describe the drawbacks of increasing the number of cores in a processor.
State \textbf{three} differences between Dynamic RAM (DRAM) and Static RAM (SRAM).
- \hrulefill
- \hrulefill
- \hrulefill
Web browsers use Internet Protocol (IP) addresses.
Complete the table by describing the following types of IP address.
\begin{tabular}{|c|p{10cm}|} \hline \textbf{Type of IP address} & \textbf{Description} \ \hline Static & \newline\newline \ \hline Public & \newline\newline \ \hline \end{tabular}
Consider the following IP address:
Circle whether this IP address is IPv4, IPv6 or an invalid IP address.
\begin{center} IPv4 \quad\quad IPv6 \quad\quad Invalid \end{center}
Justify your choice.
A user types a Uniform Resource Locator (URL) into the address bar of a web browser to access a web page.
Explain how the web browser uses the URL to access the web page.
A bitmap file is downloaded. The image has a maximum of 256 colours and measures 512 pixels wide by 2048 pixels high.
Calculate an estimate of the file size of the bitmap in kibibytes.
Show your working.
File size of bitmap \hrulefill kibibytes
Explain why the actual file size may be larger than the one calculated in (d)(i).
Explain how a bitmap image is compressed using run-length encoding (RLE).
One ethical consideration for a student connecting their personal computer to the school network is the risk of spreading malware on the network.
Viruses and pharming are examples of malware.
Explain what is meant by a virus and pharming.
Virus \hrulefill
Pharming \hrulefill
Give \textbf{three} other ethical considerations for a student using their personal computer to connect to the school network.
- \hrulefill
- \hrulefill
- \hrulefill
Describe \textbf{two} social impacts of students using Artificial Intelligence (AI) to complete their homework.
- \hrulefill
- \hrulefill
Describe the differences between a monitoring system and a control system.
An architect needs a model of a building.
Explain how the model will be printed using a 3D printer.
State why a 3D printer needs a buffer.