State and explain four network communication devices
A company has decided to deliver its products online to international customers. It has employed you as a project manager to determine whether this is a viable business decision. You choose to conduct a feasibility study. Outline the purpose of a feasibility study using two components associated with this process.
Briefly describe three types of database models
Give one advantage using a star network rather than a ring network.
Give two other uses of hexadecimal in computer science.
Journalists are issued with laptops when they start working at a magazine publishing company. The company only uses free open-source software (FOSS).
The laptops are equipped with either an HDD or an SSD.
The journalists can access their data remotely using virtualisation or Software
as a Service (SaaS).
2.3.1 Define the term virtualisation. (1)
2.3.2 Office365 is an example of SaaS.
(a) Except for remote data access, state TWO benefits of using
SaaS. (2)
(b) Describe how the license model of SaaS works. (2)
2.1.1 Explain the concept of open source in the context of FOSS. (2)
Give ONE example of a free operating system the company could install on a laptop. (1)
2.1.3 State TWO disadvantages of using free open-source software.
Confidential information about the students is to be stored on the computer system. Explain the measures that can be taken to ensure that such information remains confidential.
- Passwords
- Hierarchy
- Only allow some staff to access student files
- Only some machines able to access
- Physical location of these machines
- Physical lock on machines
- Encrypted data in files
- Firewall if connected to the Internet
Give two reasons why hexadecimal is often used instead of binary in computer
science.
A protocol is used to securely transmit the data for the website to the browser.
(i) State the name of this protocol.
(ii) Identify how this protocol changes the data to transmit the data securely.
(i) State the name of this protocol. HTTPS
(ii) Identify how this protocol changes the data to transmit the data securely.
Outline a factor that can influence the performance of a network.
Using an example, explain a difference between a primary key and a foreign key in a relational database.
A primary key is a table field that uniquely identifies each record and ensures that duplicate entries are not allowed
A foreign key is primary key of a parent table placed in a child table to ensure that any record added to a child table is related to the one in parent table.
A foreign key is a field (or a set of fields) in one table that refers to the primary key of another table. It is used to establish and enforce a link between the data in the two tables, ensuring referential integrity.
Maranda MOCK 2024 CRE Paper 2
b) What Simeon and Anna said about the life of Jesus during the dedication. (7mks)
Jesus would save people
He would bring glory to Israel
He would be a light to the gentiles
He would be a universal savoir
He would bring judgment to the Israelites
Many people would oppose his work
He would reveal secret thoughts of people
He would be the source of redemption for Jerusalem
Give one application of each type of data transmission. Each application must be different
Parallel
Serial
Define the following
(a) Cookies
(b) Spyware
(c) Phishing
(d)Spam
(e) Pharming
(a) Cookies
(b) Spyware
(c) Phishing
(d)Spam
(e) Pharming
Differentiate between Physical and logical topologies
Describe what the traffic control program should do when an emergency occurs.
give uninterrupted path through the system of linked traffic lights/
green link - wave
turn all lights to red
activate emergency generator
alarm
There are security concerns associated with cloud storage.
(a) State one way in which providers of cloud storage could prevent security breaches by their own employees
(b) Explain why data on networks is encrypted
(a) One from:
(b) To prevent unauthorised access (1) so that data remains confidential (1) by making it unintelligible (1) because it is scrambled (1)
Distinguish between application and system software
A family has purchased a computer system with the following specification:
Processor speed 2200 MHz
RAM 512 Megabyte
Hard disk drive 120 Gigabytes
CD ROM
DVD writer
Modem 56k
Monitor 17"
(a) The computer has been purchased for buying goods and services over the Internet. Explain how each of these items of hardware would be used for this purpose.
Hard disk drive
RAM
DVD writer
Modem
Hard disk drive
RAM
DVD writer
Modem
Describe two possible causes of computer failure. In each case state how it could have been prevented