CS MOCK PAPER REVIEW

Theory & Coding

MOCK JANUARY 2024 – REVIEW POINTS

Multiple Choice

For any device attached to a network, which communicates and sends/receives data across the network - it has TWO unique numbers associated with it.

What is the name, or term given to the number on the TOP of this image - 9C-35-5B-5F4C-D7 - which uniquely identifies this hardware?

• domain name

• Ethernet address

• IP address

• MAC address

Q1

Computer Systems

Question 1F

Utility software is a type of system software used
for maintaining and managing a computer system. (MM)

An Operating System has built-in utilities but
users can install more utilities as well.
Operations covered by utility software include:

4

Features of von Neumann architecture

An instruction is fetched, decoded and executed on every clock tick. The faster the processor, the faster this
happens.
A computer using von Neumann is one where:

1.Data and instructions are stored in the same memory (known as a 'stored program').
2.Program instructions are carried out one at a time by the processor using the 'fetch-decode-execute' cycle.
3.The processor has a control unit and an arithmetic & logic unit
4.Data can be processed from input devices (e.g keyboards) and sent to output devices (e.g. screens)
5.Data and programs can be stored on secondary storage (for long-term storage)

Multiple Select

Which of these are a type of bus that connects internal components?

• Data bus

• Address bus

• Control bus

• Venga bus

Multiple Choice

Maximum number of addressable locations in an address bus with 8 lines?

• 256

• 64

• 8

• 800

Question 2

5

How networks are made from 'layers' of technology
You have probably realised that networks are made up of
lots of different parts – from web browsers to switches to
cables and microwaves. These different parts exist on
different ‘layers’ that know how to talk to each other.

7

What a network layer is
A 'layer' is a division of network functionality. It is any 'hardware'
or 'software' that data travels through on a network
You need to learn the above paragraph by heart!
The sender will send data down the layer stack from 4 to 1. At
the recipient end, the data goes back up from layer 1 to 4:

Match

Match the following topologies to their diagrams

Bus Topology

Mesh Topology

Star Topology

Ring Topology

• Bus Topology

• Mesh Topology

• Star Topology

• Ring Topology

Match

Match the following PDUs with their corresponding layer of the OSI Model

• Physical Layer

• Data Link Layer

• Network Layer

• Transport Layer

• Application Layer

Bit

Frame

Packet

Segment

Data

• Bit

• Frame

• Packet

• Segment

• Data

Multiple Choice

What is a protocol?

• Any peripheral device
• A person that uses a client
• Rules for networks and communications
• A circuitboard with the components to send/receive data

Multiple Choice

What is TCP used for?

• To send information across the internet in packets
• To ensure that information is sent to the correct computer
• To send mail across the internet
• To transmit webpages across the internet

Open Ended

BONUS: Tell me why knowing these models are important in understanding a network.

8

Key terms: LAN, WAN, MAC address

A LAN is a local area network. It covers small geographic
area. When joined together, for example using public
telecommunications equipment, they form a WAN (wide
area network). The biggest WAN in the world is....The
Internet.
Every network device has a MAC (media access code).
This unique number is used by a device to address data to
another specific device on a local network.

The 'about' section of a mobile phone will show the MAC
addresses used by its WiFi and Bluetooth adaptors.
If you get someone to tell you the first three parts of the
MAC address then you can use websites like thisto be able
to find out who manufactured the phone.

9

The impact of security breaches

The impact of a single security breach can be far-reaching. For example,
if customer data is stolen then this can result in:
•Customer's financial data is used for fraud
•Identity theft of the customer
•Business closure owing to systematic data loss, e.g. via ransomware
•Fines levied on the business for breaching data protection laws
•Loss of reputation for the business
•Loss of possible future custom as customers decide to go elsewhere.
•Blackmail
•In the case of data loss or disruption, the complete destruction of a
business

Question 3

11

What malware is

'Malware' means malicious software, that is is software
designed to disrupt or damage a computer system, e.g.
•Encrypt data to extort money
•False advertising
•Data theft or modification
•Disable or destroy hardware
•Sending spam
•Mining cryptocurrency for criminals

Malware game

Multiple Select

Select all of the physical methods of security from the list below:

• Biometrics to access the computer

• Biometrics to access the room the computers are stored in

• Security Cameras

• Account locking

Multiple Select

Select all of the software methods of security from the list below:

• Passcode to log in to the computer

• Key card to access the room

• Access Levels

• Firewall

Multiple Choice

Which type of security measure is: Pin code to access a computer room

• Software

• Physical

Multiple Choice

I want to be able to watch and montior exactly who is entering the computer rooms at school and make sure people accessing the room are only the people allowed to. Which would be the most effective way to do this?

• Network access logs for the computers in the room

• Security Camera inside and outside the room.

• Key cards access to the door into the room.

• Giving user accounts and passwords to only the people I allow to use the computers.

Multiple Choice

What is data theft?

• Gain personal information such as credit card to do tax fraud and so on against the law

• A piece of code or software that gives you free fake inforation to do nothing

• A piece of code or software that just does nothing

• Data theft? Never heard of it.

Question 4

13

In computer science, a record (also called a structure, struct, or compound data) is
a basic data structure. Records in a databaseorspreadsheet are usually called "rows".

Multiple Choice

A program contains a 2D array ("CUSTOMER") storing customer numbers, first names and surnames

What data is held in stored in CUSTOMER (2,3)?

• Amrit

• Kahn

• Power

• 1003

Multiple Choice

Given the code, what is in values[2][1] ?

• 7.9

• 9.2

• 7.3

• 0.5

Multiple Choice

A collection of fields that describe one item

• table

• record

• field

• database

Multiple Choice

A sports club needs to store information about each member.  The individual information about each member is called a:

• Field
• File
• Table
• Record

4d Linear Search

14

Searching very important to know

Multiple Choice

Merge Sort

• A sorting algorithm - example of a divide-and-conquer algorithm: 1) splits list in half (2nd sub-list should start at middle item). 2) keeps repeating step one on each sub-list until all the lists only contain one item. 3) merge pairs of sub-lists and sort the items into the right order. 4) repeat step 3 until you have merged all the sub-lists together.
• File size = colour depth x number of pixels
• erroneous, boundary, normal
• Subroutines can be developed in isolation, independently or separately; Easier to discover errors/testing is more effective (than without a structure); Subroutines can be updated without affecting the overall program.

Multiple Choice

Using a binary search why will the number 9 never be found in the following list:
11, 8, 13, 9, 7, 3

• It does not work on numbers
• It only works on letters
• The list is not in order

Multiple Choice

Which type of sort algorithm is this?

• Insertion
• Bubble
• Merge

Multiple Choice

What would the list [9, 6, 12, 7, 3, 16, 10] look like after one iteration of the Bubble sort algorithm (smallest to biggest)?

• [6, 9, 7, 3, 12, 10, 16]

• [3, 9, 6, 12, 7, 16, 10]

• [3, 6, 7, 9, 10, 12, 16]

• [9, 6, 12, 3, 7, 16, 10]

Multiple Choice

What is the standard Scientific measurement for measuring algorithm efficiency?

• Big-O notation

• Scientific notation

• Floating-point

• Mbps

Multiple Choice

The following lists represent 3 passes of a sorting algorithm. Which algorithm is being used to sort the list?
 
4    5    9    6    2    7
4    5    6    2    7    9 
4    5    2    6    7    9

• Bubble Sort
• Selection Sort
• Insertion Sort

4f Decomposition

15

4f Abstraction

16

The process of 'abstraction' can help designers and
programmers to prioritise which features of a
programme should be created first without getting
too bogged down with details.

Multiple Choice

What is an Algorithm?

• Something a computer does to think

• A series of steps and instructions with given inputs to produce an output

• Some instructions

• A series of steps and instructions with given outputs to produce an input

Multiple Choice

Which of these is NOT a computational thinking technique?

• Coding

• Algorithm Design

• Decomposition

• Pattern Recognition

Match

Match the following:

• Why did O'Keefe paint Red Poppy?

• Why did Klee paint Senecio?

• Why did Kandinsky create Improvisatio

• Why did Mondrian create Broadway Boog

• Why did the Gutai Group create Work?<

To get people to slow down and look

To honor a famous comedian

To show a sea battle

To show love of New York City and music

To experiment in materiality

• To get people to slow down and look

• To honor a famous comedian

• To show a sea battle

• To show love of New York City and music

• To experiment in materiality

Multiple Choice

When designing a sat nav, would you keep or remove the location of your car

• Keep
• Remove

Multiple Choice

When creating a model of a cat, which of these can we leave out

• Cats meow
• Cats have 2 ears
• Cats have long tails
• Cats have 4 paws

Multiple Choice

You can use abstraction to replace specific objects with simple shapes

• True
• False

Multiple Choice

Which is an example of decomposition

• Watching a mechanic repair a car
• Looking how a car works and in detail at different parts
• Looking at different car models for similarities
• Looking at the steps needed to make a car

Multiple Choice

What is pattern recognition

• Removing unnecessary details to simplify a problem
• Planning clear steps to solving a problem
• Breaking a problem down into more manageable chunks
• Looking for similarities in problems

Divider

17

30/01/2024

ADD A FOOTER

Question 5

Multiple Choice

What is the missing value ? from this truth table for OR
 

• 1
• 0

Multiple Choice

What is this an example of?

• Overflow error
• 8 bit binary addition

Multiple Choice

Convert the hexadecimal number C9 to binary

• 1100 1001
• 1100 1000
• 1100 1010
• 1100 0101

Multiple Choice

In a logical _____ shift we multiply by 2 for each shift place.

• Left
• Right
• Right and Left

Multiple Choice

In a logical _____ shift we divide by 2 for each shift place.

• Left
• Right
• Right and Left

Multiple Choice

Shift 01101000 to 3 places to the right

• 00110100
• 00001101
• 00011010

Multiple Choice

When we have a 'one-bit' colour, which are the only two binary numbers that are possibilities?

• 00 and 11
• 000 and 111
• 0 and 1
• 0000 and 1111

Multiple Choice

How many combinations are there for a '2 bit' colour?

• 8
• 4
• 16
• 32

Multiple Choice

Encrypt the word alphabet using a Caesar cipher with a shift of 3

• DVSDULQV

• DOOFOHDU

• DOSKDEHW

• DORQHBHV

Question 5

Convert binary (00000000 to 11111111) to hexadecimal (00 to FF)

Multiple Select

Choose two statements that are True about an arithmetic RIGHT shift operation ...

• The MSB is always retained

• The LSB is always lost

• The MSB is shifted right

• The LSB is always retained

Multiple Select

Choose two statements that are True about an arithmetic LEFT shift operation ...

• The MSB is shifted left and out

• A 0 is shifted in to become the LSB

• The MSB is shifted right and out

• A 0 is shifted in to become the MSB

Question 5

Not Just for interest: Compact Disc audio has a sample
interval of 44,100Hz and a sample size of 16-bits for each of
the two stereo channels. This that 2 x (44,100 x 16) =
1,411,200 bits are needed to represent every second of audio!
A very similar sounding MP3 audio file can reduce this to
128,000 bits per second (128 kbps) by using very clever data
compression techniques.

Multiple Choice

The number of samples taken per second is called the...................

• Sample rate.
• ADC rate.
• Vertical rate.
• Digital rate.

Draw

Draw an example of an analogue wave

Multiple Choice

Which of these equations will give you the size of a sample? (File)

• (Number of samples per minute) x (Number of bits per sample) x (Length of sample in seconds)

• (Number of samples per second) x (Number of bits per sample) x (Length of sample in minutes)

• (Length of sample in seconds) x 4

• (Number of samples per second) x (Number of bits per sample) x (Length of sample in seconds)

Multiple Choice

What is the ASCII code for ... A?

• 65
• 56
• 97
• 79

21

CODING QUESTIONS