State two computer-based careers that have arisen as a result of computer-based data processing in a factory (2 marks)
System analyst
Web designers
Network administrators
Database administrators
Programmers
Computer technicians
Explain the difference between main memory and secondary storage.
State examples of wireless transmission media
How many hard disks are required to implement RAID 10?
Explain, using examples where appropriate, the meaning of these computer terms
(a) byte ..................................................................................................................................
..........................................................................................................................................
......................................................................................................................................[2mks]
(b) compiler ............................................................................................................................
..........................................................................................................................................
......................................................................................................................................[2mks]
(c) handshaking .....................................................................................................................
..........................................................................................................................................
......................................................................................................................................[2mks]
(d) technical documentation ..................................................................................................
..........................................................................................................................................
......................................................................................................................................[2mks]
(e) simulation .........................................................................................................................
..........................................................................................................................................
......................................................................................................................................[2
(a) byte
(b) compiler program
(c) handshaking
(d) technical documentation
(e) simulation
Explain what is meant by the two terms download speed and upload speed
download speed :
– speed at which information/data is transferred FROM server/Internet
– speed at which information/data is transferred TO the user’s computer
upload speed :
– speed at which information/data is transferred FROM user’s computer
– speed at which information/data is transferred TO the Internet/server
Describe the principles of operation of laser printers and describe how they are applied in real-life scenarios
Steps
Interfaces enable computer users to interact with the operating system. State three advantages of using a graphical user interface (GUI) for loading programs and files.
Describe one effect of not having primary keys in tables in a relational database
Without a primary key, a table in a database may have duplicate rows, making data not uniquely identifiable. This can lead to issues with data integrity and challenges in maintaining relationships between tables. Retrieving and updating specific records becomes problematic, and setting referential integrity constraints is impossible, potentially leading to loss of data.
Explain how the techniques of
(i) verification,
(ii) validation
are used to ensure that the stored data is as accurate as possible.
Dual input of data
Rules are given to the processor
Drop-down list/radio buttons
List two primary functions of a domain name server.
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.
Explain one drawback to a user if the program is distributed as freeware
The user is not allowed to access the source code so, they cannot tailor the software to their needs and they cannot fix any bugs in it
The software is still covered by copyright
The user must get the owner’s permission to do anything beyond using it
Identify and describe four roles of the operating system when managing the resources of a personal computer.
Manages memory (RAM)
Ensures programs/data do not corrupt each other: Ensures all programs and data including itself is stored in correct memory locations
Manages processes: Ensures different processes can utilise the CPU and do not interfere with each other or crash •
Allows a user to run programs : On a multi-tasking O/S ensure that all tasks appear to run simultaneously
What characterises a phased implementation approach?
- Phased means that only one part of the system is implemented at a time
Differentiate between object code and source code
Give four features of a Data Protection Act
(ii) State what ROM and RAM store.
ROM stores BIOS / bootstrap / start-up
RAM stores currently executing programs and data
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
What is a primary key?