Describe how the database can be recovered from a system failure
State two reasons why the data in fields such SEX field in a database should be coded.
A workshop has a lot of heavy machinery operating throughout the day and requires a cable to connect a workstation to a switch. Which of the following, unshielded twisted pair (UTP) or shielded twisted pair (STP) cable, would be the more suitable? Justify your response.
Shielded twisted pair cable:
A twisted pair cable is made up of four pairs of twisted copper wires, a shielded twisted pair cable applies a shield to each one of the pairs on a cable or to all of the pairs together. This shield can reduce EMI (electromagnetic interference), which would be emitted from heavy machinery. This increased data transmission quality in the workshop. STP can also reduce crosstalk.
When an image is inserted in a DTP document is selected, handles on its placeholders appear. State three uses of these handles
Explain one reason why a computer needs to be connected to a stable power source
System Stability: Computers require a consistent and stable power supply to function properly. Fluctuations or interruptions in the power source can cause various issues that can disrupt the computer's operation or lead to hardware damage.
a. Data Loss: Sudden power outages or voltage fluctuations can cause the computer to shut down abruptly, resulting in data loss if unsaved work is not properly stored. This can be particularly problematic when working on critical tasks or handling important files.
b. Hardware Damage: Power surges or inconsistent power supply can damage the computer's internal components, including the motherboard, CPU, memory, and storage devices. These damages can result in system instability, reduced performance, or even complete hardware failure.
c. Operating System Corruption: Abrupt power loss or inconsistent power supply can corrupt the operating system files, leading to system crashes, error messages, and instability. This may require system repairs or reinstallation of the operating system.
d. Component Lifespan: Inconsistent power supply can put unnecessary stress on computer components, shortening their lifespan. Frequent power fluctuations or surges can cause wear and tear on various parts, reducing their efficiency and overall longevity.
State the difference between radio waves and microwave transmission
Describe how the denial of service strategy works to compromise the security of networks.
Explain the following terms
(a) Disk mirroring
(b) Encryption
(c) Backup
(a) Disk mirroring- Data is written on two or more disks simultaneously.
(b) Encryption - Contents are scrambled so they cannot be understood without a decryption key
(c) Backup - A copy of the data is taken and stored in another location
Explain how virtual memory can compensate for the limited RAM capacity in a computer.
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 situations are likely to call for the use of Direct Changed Over?
Give an example of where a PAN could be used
Social engineering is where someone is tricked or manipulated into providing secure information or access to a secure system. Describe each of the following social engineering techniques.
Blagging
Phishing
Shouldering
A typical computer’s main memory consists of both volatile and non-volatile memory.
a) i) Explain what is meant by the term volatile memory (1mark)
ii) What is normally stored in the non-volatile part of a computer’s main memory (1mark)
b) Explain why having cache memory can improve the performance of the CPU (2mks)
Explain why solid state storage is the best choice for a fitness tracker.
OR
OR
Describe the role of the one-dimensional array in programming
Identify two advantages to a programmer of using a high-level language instead of a low-level language.
Aeroplanes now use Global Positioning Systems (GPS) to determine their location.
Describe how the computer on board the aeroplane uses GPS to find its exact location
Give two benefits of using GPS in this application
Describe how the computer on board the aeroplane uses GPS to find its exact location
– satellites transmit signals to onboard computers
– computers receive/interpret these signals
– system depends on very accurate timing/use of atomic clocks
– each satellite transmits data indicating location and time
– computer in aeroplane calculates location based on at least three satellites
– at least 24 satellites in operation at any one time
– position accurate to within one metre
– can also calculate altitude of aeroplane
– ref to “triangulation”:
Give two benefits of using GPS in this application
– safer as the known location is exact/more accurate
– reduces the possibility of pilot error
– allows accurate estimation of arrival time
– display and guide the pilot to the nearest airport in case of emergency
At which stage of the system development life cycle does the changeover to a new system take place?
There are many different types of errors that can occur when developing computer programs. (a) State the name of the two different types of programming error described below.
(i) Unexpectedly halts the program.
(ii) The program produces the wrong output.
(b) Another error can result from incorrectly using the rules or grammar of the programming language.
(i) Name this error.
(ii) State when this error is detected.
(i) Unexpectedly halts the program. Run time (execution)
(ii) The program produces the wrong output. Logical
(b) Another error can result from incorrectly using the rules or grammar of the programming language.
(i) Name this error. Syntax
(ii) State when this error is detected.
Syntax error is detected during translation into executable code / attempted to run but fails