9618/11

Computer Science 9618/11October/November 2025

Cambridge AS Level · Theory Fundamentals · worked solutions for every part, with the mark scheme

10
questions
75
marks
90
minutes

Topics Hardware · Information Representation · Processor Fundamentals · Security, Privacy and Data Integrity · Databases · System Software · +2 more

Q1Medium-EasyInformation Representation
(a)
4M
(i)

Convert the binary number into hexadecimal.

101100111010

.....................................................................................................................................

1M
(ii)

Convert the denary number into Binary Coded Decimal (BCD).

108

.....................................................................................................................................

1M
(iii)

Convert the 12-bit two’s complement binary integer into denary.

Show your working.

111110111100

Working .............................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................

Denary value ..................................................

2M
(b)
3M
(i)

The following binary addition is performed using 8-bit registers.

Complete the calculation using binary addition.

  1 0 1 1 0 0 1 1
+ 0 1 1 1 1 0 0 0
-----------------
1M
(ii)

Name and describe the error that can occur when binary addition is performed.

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
Q2MediumDatabases

A relational database, 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:

STUDENT(StudentID, FirstName, TelephoneNumber, UniversityName)

PLACEMENT(PlacementID, StudentID, CompanyID, StartDate, EndDate, Complete)

COMPANY(CompanyID, CompanyName, MaxStudentsPerPlacement)

(a)

Complete the entity-relationship (E-R) diagram for the database WORKEXPERIENCE.

2M
(b)

Explain why the database WORKEXPERIENCE is in Third Normal Form (3NF).

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

2M
(c)

Some example data from the PLACEMENT table is shown:

PlacementIDStudentIDCompanyIDStartDateEndDateComplete
PC001LDEA01MSCM01/01/202312/07/2023TRUE
PC002LDEA01MSCM01/04/202408/05/2024FALSE
PC003ALAU02NEAM09/03/202010/03/2021FALSE
PC004LOLI75GOUZ07/06/201811/09/2018TRUE
6M
(i)

Write a Structured Query Language (SQL) script to delete all placements that have been completed.

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
(ii)

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.

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

4M
(d)

The database tables are repeated here:

STUDENT(StudentID, FirstName, TelephoneNumber, UniversityName)

PLACEMENT(PlacementID, StudentID, CompanyID, StartDate, EndDate, Complete)

COMPANY(CompanyID, CompanyName, MaxStudentsPerPlacement)

Explain what is meant by referential integrity, and how it applies to this database.

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

3M
Q3Medium-EasyHardware
(a)

Draw a logic circuit for the logic expression:

X=NOT ((A NAND B) XOR (NOT A OR NOT C))X = \text{NOT } ((\text{A NAND B}) \text{ XOR } (\text{NOT A OR NOT C}))

2M
(b)

Write the logic expression for the following truth table.

RSTQ
0000
0011
0100
0110
1000
1010
1101
1110

Q = ......................................................................................................................................

2M
Q4Medium-EasyProcessor Fundamentals

The table shows part of the instruction set for a processor. The processor has one register, the Accumulator (ACC).

InstructionExplanation
OpcodeOperand
AND#n / Bn / &nBitwise AND operation of the contents of the ACC with the operand
ANDBitwise AND operation of the contents of the ACC with the contents of
XOR#n / Bn / &nBitwise XOR operation of the contents of the ACC with the operand
XORBitwise XOR operation of the contents of the ACC with the contents of
OR#n / Bn / &nBitwise OR operation of the contents of the ACC with the operand
ORBitwise OR operation of the contents of the ACC with the contents of
LSL#nBits in ACC are shifted logically n places to the left. Zeros are introduced on the right-hand end.
LSR#nBits in ACC are shifted logically n places to the right. Zeros are introduced on the left-hand end.

<address> can be an absolute or symbolic address
# denotes a denary number, e.g. #127
B denotes a binary number, e.g. B10010001
& denotes a hexadecimal number, e.g. &4A

(a)

The ACC currently contains the following positive binary integer:

00011110

Write a bit manipulation instruction that uses a binary shift to change the contents of the ACC to:

01111000

Instruction ...........................................................................................................................

1M
(b)

The ACC currently contains the following positive binary integer:

11100011

Write the contents of the ACC after the instruction XOR &12 is carried out.

1M
(c)

The ACC currently contains the following positive binary integer:

11100011

Write the contents of the ACC after the instruction AND #63 is carried out.

1M
(d)

The ACC currently contains the following positive binary integer:

11100011

The current contents of memory are:

AddressData
9800100100
9900110001
10000110011
10110100011
10210101100

Write the contents of the ACC after the instruction OR 100 is carried out.

1M
Q5Medium-EasySystem SoftwareSecurity, Privacy and Data Integrity

The Operating System (OS) is responsible for hardware and security management in a computer system.

(a)
4M
(i)

State two tasks that are performed by hardware management.

1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................

2M
(ii)

State two tasks that are performed by security management.

1 ........................................................................................................................................
...........................................................................................................................................
2 ........................................................................................................................................
...........................................................................................................................................

2M
(b)
4M
(i)

Describe one benefit of using library routines when developing software.

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
(ii)

Describe one drawback of using library routines when developing software.

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
(c)

Identify two presentation features found in a typical Integrated Development Environment (IDE).

1 ................................................................................................................................................
2 ................................................................................................................................................

2M
Q6Medium-EasyProcessor FundamentalsHardware
(a)

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.

RegisterRole
ACC.............................................................................................................................
.............................................................................................................................
CIR.............................................................................................................................
.............................................................................................................................
2M
(b)

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.

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

2M
(c)

State three differences between Dynamic RAM (DRAM) and Static RAM (SRAM).

1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................

3M
Q7Medium-EasyCommunicationInformation Representation

Web browsers use Internet Protocol (IP) addresses.

(a)

Complete the table by describing the following types of IP address.

Type of IP addressDescription
Static...........................................................................................................
...........................................................................................................
Public...........................................................................................................
...........................................................................................................
2M
(b)

Consider the following IP address:

256.0.0.A

Circle whether this IP address is IPv4, IPv6 or an invalid IP address.

IPv4      IPv6      Invalid

Justify your choice.

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

2M
(c)

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.

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

4M
(d)

A bitmap file is downloaded. The image has a maximum of 256 colours and measures 512 pixels wide by 2048 pixels high.

6M
(i)

Calculate an estimate of the file size of the bitmap in kibibytes.

Show your working.

Working .............................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................

File size of bitmap ......................................................... kibibytes

2M
(ii)

Explain why the actual file size may be larger than the one calculated in (d)(i).

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
(iii)

Explain how a bitmap image is compressed using run-length encoding (RLE).

...........................................................................................................................................
...........................................................................................................................................
...........................................................................................................................................
.....................................................................................................................................

2M
Q8Medium-EasySecurity, Privacy and Data IntegrityEthics and Ownership

One ethical consideration for a student connecting their personal computer to the school network is the risk of spreading malware on the network.

(a)

Viruses and pharming are examples of malware.

Explain what is meant by a virus and pharming.

Virus ..........................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................

Pharming ..................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................

2M
(b)

Give three other ethical considerations for a student using their personal computer to connect to the school network.

1 ................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................

3M
(c)

Describe two social impacts of students using Artificial Intelligence (AI) to complete their homework.

1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................

4M
Q93MMedium-EasyHardware

Describe the differences between a monitoring system and a control system.

..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
..........................................................................................................................................................
....................................................................................................................................................

Similar questions
Q10Medium-EasyHardware

An architect needs a model of a building.

(a)

Explain how the model will be printed using a 3D printer.

...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
.............................................................................................................................................

3M
(b)

State why a 3D printer needs a buffer.

...................................................................................................................................................
.............................................................................................................................................

1M