Distinguish between a PAN and a LAN
A PAN exist around a single person whereas a LAN covers a larger area
State two functions of utility software
Describe how the database can be recovered from a system failure
There are four change-over methods used in the implementation stage of the system development life cycle (SDLC): direct change-over, phased, parallel and pilot.
Direct Change-Over
Phased
Define the term variable as used in programming
A variable is a memory location used to store a value
Distinguish between real time processing and interactive processing
Compare the use of a compiler with the use of an interpreter to translate code
Both translate source code written in high level programming languages into machine code.
Compiler: Produces a single executable file that is portable between machines
Interpreter: Source code needs a special environment to run
Compiler: Needs to be compiled for a particular architecture
Interpreter: Can run on any architecture that has the translator/interpreter
Complier: Entire source code file is translated at once
Interpreter: Code is translated line by line
Compiler: Provides error report at the end of the compilation
Interpreter: Errors more obvious in the sequence
Compiler: The program source code is not available (so helps protect IP)
Interpreter: Source code is available
Compiler: Only has to be translated once (affecting the speed of execution)
Interpreter: Has to be translated each time, therefore (affecting the speed of execution)
Compiler: Requires two files to be maintained (one for execution and for editing purposes)
Interpreter: Requires only one file to be maintained
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.
State what is meant by Computer Aided Design (CAD).
Give three different applications that make use of CAD.
Name three specialist input/output devices used in CAD.
– software that can be used to design new products/amend existing products
– makes use of features such as 2D, 3D, wire frames, library of parts, links to CAM
Give three different applications that make use of CAD.
– aerospace
– architecture
– designing cars
– designing consumer goods
– chemical/nuclear plant design
– designing electronic circuit boards
– ergonomic design
– landscape/garden design
Name three specialist input/output devices used in CAD.
– large monitor/screen with hi-res
– touch screen
– plotter
– space mouse/space ball/4D device
– 3D glasses (in some applications)
– light pen
– graphics tablet
– 3D printer
– 3D scanner
Define what is meant by a ‘network protocol
Your friend wishes to install a wireless network in his office. Explain to him the difference between guided and unguided media
Explain what happens in the computer during the booting process
The booting process is the sequence of events that occur when a computer is turned on or restarted. It involves a series of steps that allow the computer's operating system to initialize and become functional. Here's a simplified explanation of what happens during the booting process:
Power-On Self-Test (POST): When the computer is powered on, the first thing it does is perform a Power-On Self-Test. During this step, the computer's hardware components, such as the CPU, memory, and storage devices, are checked for proper functioning. The POST verifies that all essential hardware components are present and operational.
Bootloader: Once the POST is completed, the computer looks for the bootloader. The bootloader is a small program stored in the computer's firmware or on the bootable device (such as the hard drive or a USB drive). It is responsible for loading the operating system.
Loading the Operating System: The bootloader locates the operating system's files and initiates the loading process. It may display a boot menu allowing the user to choose the operating system if multiple options are available. The selected operating system's core files are loaded into the computer's memory.
Kernel Initialization: The operating system's kernel, which is the central component responsible for managing system resources, is initialized. The kernel sets up essential components such as device drivers, memory management, and process management.
System Initialization: After the kernel is initialized, the operating system proceeds with system initialization. During this stage, various system services and processes are started, and hardware devices are initialized and configured. The operating system loads essential system files and prepares the environment for user interaction.
Login/Graphical Interface: Once the system initialization is complete, the user is presented with a login prompt or a graphical user interface (GUI). The user can then log in with their credentials or interact with the GUI to access the computer's functionalities.
Computer System Questions
Parallel data transmission
Serial data transmission
b) Give one benefit of each type of data transmission.
Serial
Give one application of each type of data transmission. Each application must be different
Parallel
Serial
State what is meant by the term USB
Describe two benefits of using USB connections between a computer and a device.
DVD - optical media which use one spiral track; red lasers are used to read and write data on the media surface; makes use of dual-layering technology to increase the storage capacity
ROM - non-volatile memory chip; contents of the chip cannot be altered; it is often used to store the start-up routines in a computer (e.g. the BIOS)
SSD/ Solid State Drive/memory (SSD): a non-volatile memory device that uses NAND flash memories (which consist of millions of transistors wired in series on single circuit boards)
Blue Ray - optical media that uses blue laser technology to read and write data on the media surface; it uses a single 1.1 mm polycarbonate disc
Viruses, pharming and phishing are all examples of potential Internet security issues.
Explain what is meant by each of these three terms.
Virus
Pharming - malicious code/software installed on a user’s hard drive/actual webserver
– this code redirects users to a fake website (without their knowledge)
– to obtain personal/financial information/data
Phishing - legitimate-looking emails sent to a user – as soon as the recipient opens/clicks on the link in the email/attachment, the user is directed to a fake website (without their knowledge) – To obtain personal/financial information/data
control bus- this bus carries signals used to coordinate the computer’s activities
address bus - this uni-directional bus carries signals relating to memory addresses between processor and memory
data bus - this bi-directional bus is used to exchange data between processor, memory and input/output devices
The seven stages in a von Neumann fetch-execute cycle
Modern LCD monitors and televisions use LED-backlit technology.
Give two advantages of using this new technology compared to the older cold cathode fluorescent lamp (CCFL) method
What is block operation as used in Microsoft word?
An editing or formatting procedure that is carried out on a selected block of text in a word-processing document.
A formatting or editing operation that is applied to a block of text after selecting. The block of text can be a paragraph, line, word, page or the whole document. It is much easier to apply editing or formatting to a block of text than to apply it to every single character
Describe two possible causes of computer failure. In each case state how it could have been prevented
State two ways in which data validation is implemented on an input form of a database application
Give a reason why HMTL is not regarded as a programming language
State the functions of the following features in word processors
What is a primary key?