wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Computer Science AQA A-Level Paper 2 Practice

Total questions: 55

Worksheet time: 50mins

Name
Class
Date
1.

What subcategory of software does a virus checker belong to.

a)

Operating System

b)

Translators

c)

Utilities

d)

Defragmentation

2.

Which of the following is not a resource managed by an operating system?

a)

Processor

b)

Memory

c)

I/O Devices

d)

Allocating Files on Secondary Storage

e)

Provides Virtual Machine

3.

Which layer of the TCP/IP stack determines which application layer software on the server should deal with a received request by using port numbers?

a)

Application

b)

Transport

c)

Network

d)

DataLink

4.

In the case of dictionary compression, a dictionary ...

a)

acts as a reference for a particular subject.

b)

maps sequences of characters onto values.

c)

is an electronic resource that lists words and gives their meaning.

d)

is a set of words or other text strings made for use in applications such as spellcheckers or brute-force attacks.

5.

In a DBMS, when a user starts to edit a record, others are prevented from accessing the record for the duration of the editing. What is this called?

(a)  

6.

Which form of transmission results in the clocks for the receiver and transmitter synchronising for the duration of a transmission?

(a)  

7.

Calculate the decimal equivalent of the normalised floating point representation number with an 8-bit mantissa and a 4-bit exponent, both stored using two’s complement.

1.0110010 0010

(a)  

8.

With an 8 bit mantissa and a 4 bit exponent, write the normalised floating point representation of the decimal value 0.15625

(a)  

9.

A particular computer system uses a 32-bit address bus and a 32-bit data bus. What is the maximum amount of memory, in bytes, that could be accessed?

(a)  

10.

Decrypt the ciphertext "QGOZRKT" using the Caesar cipher with the settings shown in the image.

(a)  

11.

Which of the following is not a condition required by the vernam cipher?

a)

The key must be truly random.

b)

The key must be transmitted with the data being encrypted/ rendered into ciphertext

c)

The key must not be reused.

d)

The key must be at least as long as the data to be encrypted/plaintext.

e)

The key must be kept securely

12.

Given the machine in the exampled image, how many commands can it store and work with?

(a)  

13.

Fill the blanks in the following explanation of the above assembly code.

Check if the value stored in memory location ___ is ___ times the value stored in memory location ___

(a)  

14.

The highest frequency component in a sound that is being sampled is 14,500 Hz. What should the minimum sample rate be?

(a)  

15.

Given an 8-bit mantissa and 4-bit exponent, write the normalised, two's complement representation of 58.5 in binary.

(a)  

16.

Which of the boolean equations above are incorrect? Select more than one.

a)

Equation 1

b)

Equation 2

c)

Equation 3

d)

Equation 4

e)

Equation 5

17.

Using odd parity, what is the parity bit for the following data? 0101011

(a)  

18.

A band is recording and digitising a song to make available as a download from their website.

The song lasts 3 minutes. The sample resolution is 16 bits and a sample rate of 44 kHz has been used. Calculate the minimum amount of storage space, in megabytes (MB), for the song and leave your answer with a precision of two decimal places.

(a)  

19.

Horatio is on Discord voice with his mates but his computer gives him a warning message that his microphone's ADC has failed. What is an ADC?

(a)  

20.

What is the name of the logic gate above?

(a)  

21.

Which type of computer architecture is typically used for digital signal processing?

(a)  

22.

SSID Stands for?

(a)  

23.

Some compilers produce this instead of an exe. This allows it to be platform independent.

(a)  

24.

The number of signal changes (which may occur) in a given period of time/in a second is known as...

(a)  

25.

The range of frequencies that can be transmitted across a network connection is known as...

(a)  

26.

RTS / CTS Are protocols which stand for?

(a)  

27.

In direct addressing mode, how many memory locations could a processor that used the instruction format shown above could potentially make use of?

(a)  

28.

Which type of high level programming languages will have instructions which are executed in a programmer-defined order?

(a)  

29.

What is the denary equivalent of the hexadecimal number D6?

(a)  

30.

Represent the decimal value -67 as an 8-bit two’s complement binary integer.

(a)  

31.

(a)   communication is most notably evidenced with buses, where multiple bits are sent simultaneously.

32.

Peripheral devices usually make use of __________ communication.

a)

Serial

b)

Parallel

33.

What would be the primary key for the RaceEntryAndResult table?

(a)  

34.

The ASCII code for the numeric character "0" is 48, other numeric characters follow on from this in sequence. What character is represented by the bit pattern 0011 1001 if it is an ASCII code?

(a)  

35.

Convert 0011 1001 into Hexadecimal.

(a)  

36.

Calculate the minimum size of file that could be used to store the bitmap image in the figure above. Express your answer in bytes.

(a)  

37.

Calculate the decimal equivalent of the number.

(a)  

38.

Compress the above using Run-Length-Encoding.

(a)  

39.

Which theorem states that we need to be sampling at a frequency at least twice the rate of the highest frequency that can be present in the original signal?

(a)  

40.

Which of these represents a natural number?

a)

A

b)

B

c)

C

d)

D

e)

None

41.

Which logic gate is represented by this truth table?

(a)  

42.

Complete the truth tables for the OR and NAND gates. Put them in order from top to bottom. Separate your two answers with a space.

(a)  

43.

Complete the statement.

(a)  

44.

The processor in Ella’s computer has four cores running at 2.8 GHz and the processor in Josephine’s computer has one core running at 3.2 GHz.


Which computer would be faster at serial processing?

a)

Ella's

b)

Josephine's

45.

Using abbreviations only, state one of the registers used in the fetch part of the F-E cycle.

(a)  

46.

Give the full name of RAM.

(a)  

47.

Translate &DD00 into denary

(a)  

48.

What is the result of performing the following logical operation?

00110000 OR 00000010

(a)  

49.

What is the result of performing the following logical operation?

NOT 01001111

(a)  

50.

What is the result of performing the following logical operation?

11000001 AND 00010011

(a)  

51.

What is the result of performing the following logical operation?

00000101 XOR 10001110

(a)  

52.

(a)   addressing means the operand is the datum.

53.

An attribute in one table which is a primary key attribute in another table is a (a)   key

54.
Return the name and genre of each movie with an imdb_rating greater than 5 and year greater than 2012.
a)
SELECT * FROM movies WHERE imdb_rating > 5 AND year > 2012;
b)
SELECT name, genre FROM movies WHERE imdb_rating < 5 AND year < 2012;
c)
SELECT name, year FROM movies WHERE imdb_rating > 5 year > 2012;
d)
SELECT name, genre FROM movies WHERE imdb_rating > 5 AND year > 2012;
55.

Another word for the mnemonic such as LDR, STR etc.

(a)