Past paper 2021/22

Question 1

List some peripheral devices

Answer 1

monitor, printers, keyboards, external hard drives

Question 2

What will increase the speed of a computer?

Answer 2

adding additional RAM or processors, increasing the bus speed

Question 3

What kind of storage is a USB an example of?

Answer 3

Solid State Storage

Question 4

Which entity relationship should be removed using a link entity?

Answer 4

Many to many

Question 5

Which language is the closest to english?

Answer 5

High Level Language

Question 6

Describe an interpreter?

Answer 6

translates source code into object code one instruction at a time

Question 7

What are the key features of operating system?

Answer 7

Device Management, Interrupt Management, Memory Management, File Management

Question 8

A User Interface…

Answer 8

Is an intermediary between the user and the computer hardware

Question 9

Virtual Memory…

Answer 9

Stores segments of data from RAM on other storage devices

Question 10

A Local Area Network…

Answer 10

Operates over a single building or complex. It can be a star or bus topology

Question 11

An Interrupt….

Answer 11

Is used to move the processor onto another task

Question 12

When starting up the computer, what software is key part of the start up process?

Answer 12

Boot Loader

Question 13

Which are the kinds of external attacks?

Answer 13

Data Sniffing, Virus, Spyware

Question 14

Which are parts of the TCP/IP Protocol Suite?

Answer 14

Transmission Control Protocol and User Datagram Protocol

Question 15

HTML is used for….

Answer 15

Encoding Webpages

Question 16

Which device is handled by the Device Manager?

Answer 16

A printer

Question 17

A while loop checks its condition…

Answer 17

At the beginning of the loop

Question 18

Two common types of user interface are….

Answer 18

Graphical and Command Line

Question 19

The Fetch-Execute cycle refers to…

Answer 19

The way the processor handles instructions

Question 20

Components that are a part of the CPU

Answer 20

CU, ALU, Registers, Cache, Buses, Clock

Question 21

A primary key is…

Answer 21

The unique field used to identify a record

Question 22

A foreign key…

Answer 22

Used as an attribute in another table to link tables through providing relationships

Question 23

Which device will lose stored data without power?

Answer 23

Main Memory

Question 24

With a sorted list of 500 items, how many iterations will a Binary Search take in the worst case to find the target?

Answer 24

8

Question 25

In OOP, an instance represents

Answer 25

An object create from a class

Question 26

In Relational Databases, each level of Normal Form represents...

Answer 26

Reduced opportunity for errors to arise

Question 27

Describe a relational database?

Answer 27

A series of interlinked tables

Question 28

What is recursion?

Answer 28

A procedure calling itself

Question 29

In Hardware, the role of a Bus is...

Answer 29

Moving data around within the computer

Question 30

The cache provides the CPU with...

Answer 30

Access to a smaller, faster area of memory

Question 31

Which are the standard data types used in programming languages?

Answer 31

Boolean and Integer

Question 32

What does HTTP stand for?

Answer 32

Hyper Text Transfer Protocol

Question 33

What are the elements of the Translation process?

Answer 33

Lexical Analyser and Parser

Question 34

If an algorithm is more efficient, its theta notation will....

Answer 34

be smaller

Question 35

Describe the Fetch-Execute cycle

Answer 35

Fetch: Retrieve the next instruction from memory Decode: Decode the bit pattern Execute: Perform the action described

Question 36

What is an algorithm?

Answer 36

An ordered set of unambiguous, executable steps that defines a terminating process

Question 37

What are the differences between TCP and UDP?

Answer 37

TCP is more reliable and UDP is more efficient

Question 38

Order the components of the internet

Answer 38

Tier 1, Tier 2, Access, End Systems

Question 39

An organisation known as ______ is responsible for allocating _____ to ISPs, which then distribute these to their customers. This organisation is also responsible for maintaining the register of _____ names.

Answer 39

ICANN, IP addresses, domain

Question 40

Describe Public-key encryption, how it secures messages and which messages it can secure?

Answer 40

A method of encrypting data with two different keys. A public key matches to a private key. Data encrypted with the public key can only be decrypted with the matching private key.

Question 41

Describe Binary Search algorithm

Answer 41

Identify middle entry. Round up or down. Compare to target. Eliminate above or below. Call self with remainder. Repeat until result found. Feed back the result to the parent. Present final result.

Question 42

What is an internal bus system and what does it having a different size affect?

Answer 42

A type of data bus that only operates internally in a computer or system. The number of physical wires, the size of memory location and the total amount of memory affects the size

Question 43

Four differences between Verification and Validation?

Answer 43

static vs dynamic no execution vs execution human vs computer low level vs high level

Question 44

4 types of external attacks a networked computer may be subject to

Answer 44

malware, phishing, hacking, brute force attack

Question 45

There are a number of protocols used commonly on the internet: ___ and ____ are used for email, while ___ is used for sending files from place to place. The ____ protocol is used to encrypt communication for remote terminal access and _____ is used for accessing traditional webpages.

Answer 45

POP3, IMAP, FTP, SSH, HTTP