State the seven layers of the OSI model
List two types of network software
What is the difference between a logical file and a physical file?
Maranda 2024 Mock CRE Paper 2
1. a) Based on Deutro-Isaiah, describe the Messiah. (7mks)
The Messiah would be despised/ rejected
The Messiah would be treated harshly/ arrested/sentenced to death
The Messiah would be reconciling people through His suffering
The death of the Messiah would bring forgiveness of sins of humankind
The Messiah would endure suffering/humiliation without complaining/ would suffer innocently
The Messiah would have nothing attractive
The Messiah would be humble/simple
The Messiah would be highly honored
The Messiah would succeed in His work
He would be despised, rejected, wounded oppressed and afflicted
He endured pain and suffering which would have been ours.
Because of our sins he was wounded
We are healed by the punishment he suffered He was treated harshly but he never said a word
He was put in the grave with the wicked
He was buried with the rich even though he did not commit a crime
He took the place of many sinners and prayed that they might be forgiven.
6 Programmers write software that controls hardware and interacts with users. Some of this software ensures that networks function properly.
(a) Compilers and interpreters translate source code written in programming languages.
State four other features of a compiler.
A single executable file is produced
The executable program is portable between machines
The program source code is not available
Code can be optimised/made more efficient
Entire source code file is converted at once
No special environment is needed to execute the code
It creates object/machine code
Error report is provided at the end of the compilation
State three features of the fifth generation computers (3mks) [2017 paper 1]
Explain each of the following function of an operating system
Job scheduling/Process scheduling (2mks)
Memory management (2mks)
(a) Name two pieces of hardware needed to enable video-conferencing to take place using a standard computer system.
(b) State one piece of specialist software needed to carry out video-conferencing.
(a)
– webcam
– speakers
– microphone
– broadband modem
(b)
– use of CODEC (converts/compresses analogue data into digital data)
– echo cancellation s/ware (allows talking in real time/keeps everything in sync)
– compression s/ware for video/audio
– s/ware to access broadband/networking
State the characteristics of each of the following network topologies (KCSE COMPUTER STUDIES 2021 )
i) Mesh Topology (2mks)
(ii) Ring Topology (2mks)
State the characteristics of each of the following network topologies (KCSE COMPUTER STUDIES 2021 )
i) Mesh Topology (2mks)
(ii) Ring Topology (2mks)
Identify which processor in the PC systems below is likely to process instructions more efficiently. Justify your answer.
What is utility software?
Below is a labelled diagram of a star topology network.

(a) Other than the items labelled above state the hardware required by every computer to connect to a network
b) Describe how a packet is transmitted from computer A to computer D, including the role of the switch

(a)
(b)
Describe how the database can be recovered from a system failure
Briefly describe three types of database models
Explain why the organization's management and the analyst need to work together to define the problem accurately during system development
Give one reason why a phased implementation would be the best approach to follow in this case.
When data is transmitted it is subject to corruption. Explain how a parity check could be used to determine whether corruption has taken place.
State one advantage and one disadvantage for customers of using the Internet for shopping.
Advantages
Disadvantages
Identify one component common to all computers.
When an image is inserted in a DTP document is selected, handles on its placeholders appear. State three uses of these handles