9618/12 · Oct/Nov 2025
Download PDFComplete the table by describing each term. Term | Description Copyright | Open Source (Initiative) | Shareware | Software Licence |
Describe the purpose of a code of conduct.
State what is meant by relative addressing.
Registers such as the Accumulator (ACC) and the Index Register (IX) are used in the CPU. Identify two special purpose registers used in the CPU. Do not include the ACC or IX in your answers. 1 2
The following table shows part of the instruction set for a processor. The processor has two registers: the ACC and an IX. Instruction Opcode | Operand | Explanation LDM | #n | Immediate addressing. Load the number n to ACC LDD | <address> | Direct addressing. Load the contents of the location at the given address to ACC LDI | <address> | Indirect addressing. The address to be used is at the given address. Load the contents of this second address to ACC LDX | <address> | Indexed addressing. Form the address from <address> + the contents of the index register. Copy the contents of this calculated address to ACC LDR | #n | Immediate addressing. Load the number n to IX <address> can be an absolute or symbolic address # denotes a denary number, e.g. #127 The current contents of the main memory and the index register are shown. Address | Instruction 98 | 8 99 | 16 100 | 3 101 | 98 102 | 32 IX | 2 Write the contents of the ACC after each instruction is executed. Instruction | Value in ACC LDM #98 | LDI 101 | LDX 100 |
A student buys a new computer. The table shows the specifications of the old computer and the new computer. Old computer | New computer 1.8GHz dual core processor | 2.3GHz dual core processor 16MB cache | 32MB cache Explain why increasing the clock speed and increasing the cache memory will improve the performance of the computer. Clock speed Cache memory
A relational database, SHIPPING, stores data about the ships in a company and the containers that are carried on the ships. The database has the following tables: CONTAINER(ContainerID, Type, Weight, OwnerName, ShipID) SHIP(ShipID, Type, Capacity, ShipName)
Describe the relationship between the two tables. Refer to the primary and foreign keys in your answer.
The table CONTAINER needs an additional field to store the data for the last inspection date. Write a Structured Query Language (SQL) script to add one field to the table CONTAINER to store the date of last inspection of the container, for example 08/07/2019.
Write an SQL script to return the number of containers stored in the database for the ship with the name Caledonia.
Describe the purpose of a developer interface in a Database Management System (DBMS).
A local area network (LAN) has five computers, one switch and one server.
Describe the characteristics of a LAN.
Complete the following diagram to show how these devices are connected in a star topology.
Describe how packets are transmitted between two hosts using a star topology.
Another type of network is a bus network. Ethernet is used to transmit and receive data between the devices on the bus network. Describe how collisions are detected and managed on this network.
Complete the table by identifying one threat to computer and data security posed by networks and the internet. Describe the threat and give a method of prevention. Threat | Description | Prevention
A sound file is compressed by reducing the sampling rate. State whether this is lossless or lossy compression. Justify your choice. Type of compression Justification
The following table shows some words and corresponding denary values. Word | Denary value Computing | 55 Science | 56 Computers | 57 are | 58 Brilliant! | 59 is | 60 Fun! | 61 Amazing! | 62 The following table shows three bytes of data that have been received. Use the table to find the corresponding words from the binary values received. Binary value | 00111000 | 00111100 | 00111110 Word | | | Working
A computer system uses even parity. The least significant (rightmost) bit of each byte is the parity bit. Complete the byte by writing the missing parity bit:
The computer also uses parity block check. The parity block check uses even parity. Computer A transmits four bytes of data to computer B, followed by a parity byte. Computer B receives the following sequence of bytes. 1 0 1 1 0 1 1 1 0 1 1 1 0 0 0 0 0 0 0 1 1 0 1 1 0 1 1 1 0 1 0 0 parity byte: 1 0 1 0 0 0 0 0 Following transmission, one of the four bytes of data has an error in one of the bits. Circle the bit that has been altered during the data transfer.
A bitmap image has a resolution of 1000 pixels wide by 2000 pixels high. The colour depth is 16 bits. Calculate an estimate of the file size in megabytes. Show your working. File size .......................... megabytes
The following binary addition is performed using 8‑bit registers. Complete the calculation using binary addition. 1 0 0 0 0 1 1 1 + 0 0 1 1 1 0 0 1
A computer uses the Unicode character set. State the number of bits used to store one character from the Unicode character set.
ASCII is another character set. The ASCII value for the character ‘h’ has the denary value 104. Write the Binary Coded Decimal (BCD) value for the ASCII character ‘h’.
Write the hexadecimal value for the ASCII character ‘h’.
A restaurant accesses software and stores data using cloud computing.
Give two benefits of storing data using cloud computing. 1 2
Give two drawbacks of using cloud computing. 1 2
The restaurant uses touchscreens as input devices to allow staff to select items from a menu. Explain how a touchscreen converts the point of touch to a selection from the menu.
The image files that are displayed on the touchscreen have been corrupted. Identify two examples of utility software that could be used to recover the images. 1 2
Consider the following logic circuit: Write the logic expression for the logic circuit. Do not simplify the expression. X =
Consider the following logic expression: X = NOT ((A NAND B) XOR (NOT A OR NOT C)) A truth table for the logic expression is given: Row number | A | B | C | X 1 | 0 | 0 | 0 | 1 2 | 0 | 0 | 1 | 0 3 | 0 | 1 | 0 | 1 4 | 0 | 1 | 1 | 0 5 | 1 | 0 | 0 | 1 6 | 1 | 0 | 1 | 0 7 | 1 | 1 | 0 | 1 8 | 1 | 1 | 1 | 1 There are three errors in the truth table. Identify the three errors in the truth table by writing the row numbers with an incorrect output. Error 1 Row number Error 2 Row number Error 3 Row number
A programmer is developing a computer program.
Explain how the programmer can first use an interpreter and then a compiler to develop the computer program. Interpreter Compiler
The programmer releases the program as Free Software. Describe what is meant by Free Software.
A user downloads the computer program from the internet. State what should be included as part of the download to make sure the program is authentic.
An automated system opens doors when a person is detected within 2 metres. The system closes the doors when there is no longer a person within 2 metres. Identify whether the automated system is an example of a monitoring system or a control system. Justify your choice. Monitoring or Control..................................................... Justification