All papers

Computer Science · OCR H446 · Computer systems · June 2019

OCR A Level Computer Science Computer systems June 2019 question paper H446/01

2h 30m 140 marks

Practise the past exam questions by topic

OCR H446 · Paper 1

11 questions
Report a problem
What is wrong?

Goes to whoever maintains the question split. No account needed and nothing is published on this page.

Question 1

A company releases an in-home virtual assistant called ‘Bertie Butler’.

The device, when placed in a room, listens out for the phrase “Hey Bertie”. When someone says that phrase it then listens to the question that follows and tries to give a relevant answer.

Bertie Butler has a number of built-in input and output devices.

(a)

Name one input device and one output device that might be part of Bertie Butler. For each device give a reason for it being built into the virtual assistant.

Input Device Name:........

Input Device Reason:........

Output Device Name:........

Output Device Reason:........

[4]

(b)

The Bertie Butler device runs off an embedded operating system.

Define the term ‘embedded operating system’.

[2]

(c)

Bertie Butler’s circuitry is designed to only listen out for “Hey Bertie” under certain circumstances, which are:

The privacy button (P) must be off and the microphone must generate a signal (S) to say a sound has been heard.

(c)(i)

Complete the truth table for whether the device is listening (L).

PSL
FalseFalse
FalseTrue
TrueFalse
TrueTrue

[2]

(c)(ii)

Draw logic gates to represent the circuitry needed.

[3]

(d)

The Bertie Butler machine uses a multicore processor.

Define the term ‘multicore processor’.

[2]

Question 2

A survey is carried out to look at the types of vehicle that travel down a stretch of motorway.

For each vehicle that passes by, a letter is entered into the system.

For a car ‘C’ is entered.

For a motorbike ‘M’ is entered.

For a lorry ‘L’ is entered.

For any other vehicle ‘O’ is entered.

It is decided to compress the data that has been generated.

(a)

State what is meant by the term ‘compression’.

[1]

(b)

It is decided that Run Length Encoding will be used.

The following sequence has been compressed using Run Length Encoding.

3C3M4C

Show the result of decompressing the sequence.

[2]

(c)

Show the result of using Run Length Encoding to compress the sequence:

CCCCOLLLCCCCCMOCCCCC

[3]

(d)

The survey takers want to find out the longest continuous sequence of cars in any given chunk of data. For example, in the data

CCMCCCCLLCCC

the longest sequence would be 4.

Write the function longest which takes in a string of characters as an argument and returns an integer representing the longest continuous sequence of Cs.

[5]

Question 3

A program written in the Little Man Computer instruction set is given below.

Figure for question 3
(a)

State what the program outputs are for the following inputs.

Figure for question 3

[3]

(b)

State what the purpose of the program is.

[1]

(c)

Explain which registers are used and their values when the line STA count is executed and the accumulator is holding the value 9. The label count refers to memory location 16.

[2]

(d)

Whilst the line STA count is being executed, the CPU receives a signal from another process, requiring its attention.

State the name for the signal received by the CPU.

[1]

(e)

The code uses direct addressing. Describe one other mode of addressing.

[2]

Question 4

Traditionally films have been distributed on optical media such as DVDs.

(a)

Giving an example other than DVDs, describe what is meant by the term ‘optical media’.

[2]

(b)

Give one advantage of films being distributed using optical media.

[1]

(c)

Adding a DVD drive to a computer would often require the installation of a piece of software called a device driver.

State the purpose of a device driver.

[1]

(d)

It is now common for people to purchase films which, rather than having a physical copy of, they can stream or download over the internet whenever they want.

Explain the advantages and disadvantages of owning films that are streamed or downloaded on demand rather than owning a physical copy.

[4]

(e)

Being able to stream high resolution films is only possible due to improvements in compression.

Explain why compression is important for the streaming of high resolution films.

[3]

Question 5

A programmer is writing software for a firewall. She is writing code so that it keeps a track of websites that users are permitted to visit. The software stores the websites’ addresses along with details about who can view them and when.

The following data is also stored about each website:

• Access level needed (1-4) • If it is available all the time (true) or just lunch times and out of work hours (false).

So a website which is available to users of access level 2 and above, all the time, would have the details [2, true] stored.

A website accessible to users of access level 3 and above, only outside of work hours, would have the details [3, false] stored.

(a)

State the name of a data structure that could be used to store a single site’s details.

[1]

(d)

A flaw with the current hash function is it tends to generate lots of collisions (addresses that compute to the same hash). Below is a diagram of part of the hash table. The address www.rnd.com with details [2, true] is being added to the hash table.

Explain how a hash table can be used to handle collisions, referring to the example below.

227
228www.ocr.org.uk : [1, true]
229
230www.ppf.nz : [2, false]
231
232www.ntf.biz : [4, true]
234
235

[4]

(e)

The hash function is changed so there are no longer high numbers of collisions.

During busy periods the firewall is expected to check several addresses a second. It is anticipated that roughly 10 new addresses will be added to a whitelist (list of acceptable addresses) each day.

There is a debate as to whether a hash table (with the new hash function) is the best approach, or if the whitelist would be better stored in a linked list.

*Discuss whether a hash table or linked list is better to store acceptable websites. You should compare how each structure can be searched and has data added and come to a

recommendation as to which is better for the whitelist.

[12]

Question 6

A company makes anti-virus software.

Anti-virus software is an example of a utility.

(a)

Define the term ‘utility’.

[2]

Answer
Mark scheme for question 6(a)
(b)

State how an application differs from a utility.

[1]

Answer
Mark scheme for question 6(b)
(c)

In order to keep up to date with the latest virus threats, the company is continually updating their software.

The programmers use an Extreme Programming approach when developing the updates.

Explain what is meant by Extreme Programming and why it is a suitable approach in this case.

[4]

Answer
Mark scheme for question 6(c)
(d)

Explain why the programmers of anti-virus software may make use of virtual machines when developing the updates.

[3]

Answer
Mark scheme for question 6(d)
(e)

When running the anti-virus software, an operating system uses a scheduling algorithm to determine an allocation of CPU time to the anti-virus software.

Explain why a First Come First Served scheduling algorithm would not be suitable in this situation.

[2]

Answer
Mark scheme for question 6(e)
(f)

In the late 1990s the CIH virus hit headlines because it was able to overwrite and destroy the contents of a computer’s BIOS.

Describe what the effect would be of a computer having its BIOS overwritten.

[2]

Answer
Mark scheme for question 6(f)

Question 7

RestaurantReview is a website that allows users to leave reviews and ratings for different restaurants.

The website uses a database with the following structure.

Figure for question 7

The database management system ensures referential integrity is maintained.

(a)

Explain what is meant by referential integrity, giving an example which refers to the database described above.

[3]

Answer
Mark scheme for question 7(a)
(b)

Each review includes a score out of 5. When the score is entered on the website it is checked in the browser to ensure a number no higher than 5 has been entered. It is then checked again on the server.

(b)(i)

State what is meant by the term ‘server’.

[1]

Answer
Mark scheme for question 7(b)(i)
(b)(ii)

Explain why it is important that the review score that the user entered is also checked server-side.

[2]

Answer
Mark scheme for question 7(b)(ii)
(c)

Whenever a review is added to the system, the restaurant’s average rating is updated. This transaction is ACID.

The A in ACID refers to Atomic.

Describe what is meant by the term ‘Atomic’ in the context of ACID transactions. You should refer to the example of a review being added.

[2]

Answer
Mark scheme for question 7(c)
(d)
Figure for question 7

[3]

Answer
Mark scheme for question 7(d)
(e)

The database previously stored reviews using the ASCII character set. ASCII uses 1 byte per character. It is decided to switch to the Unicode UTF-32 character set which uses 4 bytes per character.

Give an advantage and disadvantage of changing character sets from ASCII to Unicode UTF-32.

Advantage.

Disadvantage

[2]

Answer
Mark scheme for question 7(e)

Question 8

Figure for question 8
(a)

State the output of the program when the number 30 is entered.

[1]

(b)

State the most suitable data type of the variable count

[1]

(c)

State the data type of the result of the expression (count*num)<=100

[1]

(d)

State the data type of the result of the expression

str(num) + " goes into 100 " + str(count) + " times."

[1]

(e)

Write extra code so the program also displays the remainder.

[2]

(f)

The program is compiled. The first stage is Lexical Analysis.

Referring to examples in the code in Fig. 8.1, explain what happens in Lexical Analysis.

[3]

(g)

State the name of the stage of compilation that directly follows Lexical Analysis.

[1]

Question 9

9* Discuss the positive and negative impacts computers are having on the environment.

[9]

Answer
Mark scheme for question 9

Question 10

(a)

Show how the binary number 01011110 is represented in hexadecimal.

[1]

(b)

Show how the hexadecimal number 9B is represented in denary.

[2]

(c)

Show how the denary number −87 is represented in sign and magnitude binary.

[2]

(d)

Complete the following binary subtraction. Show your working.

Figure for question 10

[2]

(e)

The floating point binary number 010011 011 consists of a 6-bit mantissa and 3-bit exponent, both represented in two’s complement. Convert the number to denary, showing your working.

[3]

(f)

Show the denary number −5.25 in floating point binary form representing the mantissa and exponent in two’s complement, using as few bits as possible. Show your working.

[4]

Question 11

A web development company makes its money building websites for other companies.

(a)

* The web development company is looking to recruit a programmer to build websites.

Discuss the technologies the programmer would need to know and use and the importance of each one.

[9]

(b)

Part of a website’s code is shown below.

Figure for question 11

Explain the meaning of the code.

[2]

(c)

The site also contains the following code.

<div class="offer">All oranges 50% off.</div>

Complete the CSS code that would make any div elements of the class offer have an orange border.

Figure for question 11

[2]

The paper as printed

Spotted a mistake on this page?Report a problem