Question 1

Which of the following describes the purpose of a proxy server within a local area network (LAN)?

Accepted Answer

To act as an intermediary between a user's computer and the internet to improve security and cache web pages

Answer

To automatically assign IP addresses to every device that connects to the network

Answer

To convert digital signals into analogue signals for transmission over telephone lines

Answer

To provide a physical connection between two different types of network cabling

Question 2

Which of the following is a primary characteristic of a 'vishing' attack?

Accepted Answer

Using voice communication or phone calls to trick individuals into revealing personal data

Answer

Installing software that encrypts a user's files and demands payment for the decryption key

Answer

Using SMS text messages to encourage users to click on infected URLs

Answer

Using fake websites to capture login credentials via malicious links in emails

Question 3

In the context of data validation, which check would be most appropriate to ensure that a value entered into a 'Month' field is between 1 and 12?

Accepted Answer

Range check

Answer

Type check

Answer

Presence check

Answer

Format check

Question 4

Which of these components is considered an 'internal' hardware device used specifically to provide a computer with the ability to display high-quality graphics by taking the load off the CPU?

Accepted Answer

Video card / Graphics card

Answer

Solid State Drive (SSD)

Answer

Network Interface Card (NIC)

Answer

Random Access Memory (RAM)

Question 5

Which of the following describes the difference between SSDs (Solid State Drives) and HDDs (Hard Disk Drives) regarding data storage methods?

Accepted Answer

SSDs use flash memory to store data electronically, whereas HDDs use magnetic platters and a read/write head

Answer

SSDs are volatile memory devices that lose data when power is off, whereas HDDs are non-volatile

Answer

SSDs require a constant internet connection to synchronize data, whereas HDDs store data locally

Answer

SSDs use laser beams to burn data onto a reflective surface, whereas HDDs use flash memory

Question 6

In the context of computer networking, what is the main difference between a Hub and a Switch?

Accepted Answer

A Hub broadcasts data to all ports, while a Switch sends data only to the specific intended recipient device using MAC addresses

Answer

A Hub connects a LAN to the internet, while a Switch is only used to connect two different types of networks

Answer

A Hub provides encryption for all transmitted data, while a Switch does not provide any security features

Answer

A Hub is used for wireless connections, while a Switch is only used for wired Ethernet connections

Question 7

Which of the following describes the difference between Phishing and Pharming?

Accepted Answer

Phishing involves sending fraudulent emails to obtain user data, whereas Pharming redirects users to a malicious website by poisoning DNS or changing local host files

Answer

Phishing is only possible on mobile devices, while Pharming only affects desktop computers

Answer

Phishing involves hardware theft, while Pharming involves software piracy

Answer

Phishing uses telephone calls to interview victims, while Pharming uses physical documents to steal identities

Question 8

In a spreadsheet, if cell A1 contains the value 10 and cell A2 contains the value 5, what would be the result of the formula

=A1+A2*2

?

Accepted Answer

20

Answer

25

Answer

15

Answer

30

Question 9

Which of the following is an advantage of using a Relational Database over a Flat-file Database?

Accepted Answer

It reduces data redundancy by ensuring data is only stored once in related tables

Answer

It prevents the use of primary keys, making data entry faster

Answer

It is much simpler to set up and requires no specialized software

Answer

It stores all information in a single table, making it easier to read

Question 10

Which of the following is an example of 'Bio-metric' security being used to authenticate a user's identity?

Accepted Answer

A scanner that identifies a unique pattern in a person's iris

Answer

A plastic card with a magnetic stripe containing an encrypted code

Answer

A complex password consisting of numbers, symbols, and letters

Answer

A system that sends a one-time passcode (OTP) to a mobile phone

Question 11

In the context of data security, which of the following best describes the process of 'Pharming'?

Accepted Answer

Malicious code is installed on a user's computer or server that redirects them to a fake website even if they type the correct URL.

Answer

A technique where software tries every possible combination of characters to discover a user's password.

Answer

The use of hardware devices that record every keystroke made by a user on their keyboard.

Answer

Sending fraudulent emails that appear to be from a legitimate source to trick users into providing personal information.

Question 12

Which of the following is a primary characteristic of a 'Relational Database'?

Accepted Answer

Data is stored in multiple tables that are linked together using primary and foreign keys.

Answer

The database can only be accessed by one user at a time to ensure data integrity.

Answer

All data is stored in a single large file to prevent data redundancy.

Answer

Data is organized in a hierarchical tree-like structure with no connections between branches.

Question 13

Which of the following describes the function of the 'MAC Address'?

Accepted Answer

A unique hardware identification number assigned to a Network Interface Card (NIC) during manufacturing.

Answer

A temporary address assigned to a device by a router that changes every time it connects to the internet.

Answer

A software-based address used to identify the location of a website on a specific web server.

Answer

A protocol used to translate a human-readable domain name into an IP address.

Question 14

Which of the following describes the function of the 'SSD' (Solid State Drive) compared to an 'HDD' (Hard Disk Drive)?

Accepted Answer

It uses flash memory to store data, resulting in faster access speeds and no moving parts.

Answer

It uses magnetic platters and a moving read/write head to access data sequences.

Answer

It is an optical storage medium that uses lasers to burn data onto a reflective surface.

Answer

It is a volatile storage device that loses all data when the computer is powered off.

Question 15

Which of the following describes the function of a 'Compiler' when used in software development?

Accepted Answer

It translates the entire high-level language program into machine code all at once before the program is run.

Answer

It translates and executes a high-level language program one line at a time.

Answer

It is a type of system utility used to compress large files into a smaller format for email transmission.

Answer

It is a hardware component that increases the clock speed of the CPU during heavy processing tasks.

Question 16

Which of the following describes the difference between RAM and ROM?

Accepted Answer

RAM is volatile and stores data currently in use, while ROM is non-volatile and stores start-up instructions.

Answer

RAM is secondary storage used for long-term backups, while ROM is primary storage used for user files.

Answer

RAM can only be read from, whereas ROM can be frequently written to and deleted by the user.

Answer

RAM is non-volatile and stores the BIOS, while ROM is volatile and stores the operating system.

Question 17

Which of the following describes the main function of an SSL certificate in an e-commerce website?

Accepted Answer

To encrypt data transmitted between the user's browser and the web server to ensure secure transactions.

Answer

To prevent unauthorized users from physically accessing the server room.

Answer

To automatically scan the user's computer for malware and viruses before checkout.

Answer

To increase the speed of the internet connection when downloading large media files.

Question 18

In a spreadsheet, if cell A1 contains the value 10 and cell B1 contains the formula

=A1+A2*2

, what would be the result of the formula?

Accepted Answer

25

Answer

20

Answer

70

Answer

17

Question 19

Which of the following describes the difference between CLI and GUI interfaces?

Accepted Answer

A CLI requires users to type commands to interact with the computer, whereas a GUI uses icons and menus to represent actions.

Answer

A CLI is easier for beginners to use because it is visually intuitive, whereas a GUI is only for experts.

Answer

A CLI allows for multitasking on a desktop, whereas a GUI limits the user to one command at a time.

Answer

A CLI uses a mouse and windows for navigation, whereas a GUI is purely text-based.

Question 20

Which of the following describes the difference between 'Verification' and 'Validation' in data entry?

Accepted Answer

Validation checks if data follows specific rules or constraints, whereas verification checks if the data matches the original source.

Answer

Validation is performed by two different people entering data, whereas verification is performed by the computer automatically.

Answer

Validation ensures the user is a human, whereas verification checks that the user has the correct permissions to access the file.

Answer

Validation checks if the data is correct, whereas verification ensures the data is in the correct format.

Question 21

Which of the following is a primary characteristic of a 'Hub' when compared to a 'Switch' in a computer network?

Accepted Answer

A hub broadcasts data packets to every device on the network, whereas a switch sends data only to the specific intended recipient.

Answer

A hub provides a wireless signal for mobile devices, while a switch requires a physical fibre-optic connection.

Answer

A hub uses IP addresses to route data across different networks, whereas a switch only uses MAC addresses.

Answer

A hub is used to connect a local area network to the internet, while a switch is only used for internal file storage.

Question 22

In the context of Cascading Style Sheets (CSS), which property is used to change the space between the content of an element and its border?

Accepted Answer

padding

Answer

margin

Answer

float

Answer

spacing

Question 23

Which of the following follows the correct CSS syntax for changing the background color of all

=A1+A2*2

elements to blue?

Accepted Answer

h1 {background-color: blue;}

Answer

Answer

h1: {background-color = blue;}

Answer

h1 {color-background: #blue;}

Question 24

In the context of the IGCSE ICT syllabus, which layer of a webpage is used to define the style, layout, and appearance of the elements?

Accepted Answer

Presentation layer

Answer

Structural layer

Answer

Behavior layer

Answer

Content layer

Question 25

When defining colors in CSS using Hexadecimal codes, what is the correct color represented by the code

=A1+A2*2

?

Accepted Answer

Green

Answer

Yellow

Answer

Red

Answer

Blue

Question 26

Which of the following HTML tags is used to define an item in a list that is ordered using numbers?

Accepted Answer

<li>

Answer

<ol>

Answer

<ul>

Answer

<list>

Question 27

Which of the following describes the difference between an absolute file path and a relative file path in web authoring?

Accepted Answer

An absolute path defines the full URL including the domain, while a relative path points to a file based on the current folder location.

Answer

An absolute path can only be used in internal CSS, while a relative path is used in external CSS.

Answer

An absolute path is used only for images, whereas a relative path is used only for hyperlinks.

Answer

A relative path is more secure because it encrypts the file location on the server.

Question 28

In a web table, which HTML attribute is used to allow a single table cell to span across multiple columns horizontally?

Accepted Answer

colspan

Answer

width

Answer

rowspan

Answer

spacing

Question 29

Which of the following is the correct HTML tag used to insert a line break without starting a new paragraph?

Accepted Answer

<br>

Answer

<p>

Answer

<break>

Answer

<lb>

Question 30

Which of the following is an essential practice when optimizing an image for a webpage to ensure it loads quickly without excessive loss of quality?

Accepted Answer

Reducing the file size by adjusting the resolution and compression

Answer

Scaling the image dimensions using HTML attributes instead of editing the file

Answer

Increasing the bit depth of the image to the maximum value

Answer

Always using the BMP file format for all web graphics

Question 31

Which of the following input devices would be most suitable for a disabled user who has limited mobility in their hands but can move their head to control a computer cursor?

Accepted Answer

Head tracker

Answer

Magnetic Ink Character Reader

Answer

Touchpad

Answer

Optical Mark Reader

Question 32

Which of these storage media uses solid-state technology and is commonly used in digital cameras and smartphones due to its compact size and lack of moving parts?

Accepted Answer

SD Card

Answer

Optical Blu-ray Disc

Answer

Fixed Hard Disk Drive

Answer

Magnetic Tape

Question 33

In the context of networking and data security, which device acts as a barrier between a local area network (LAN) and the internet to prevent unauthorized access by filtering incoming and outgoing traffic?

Accepted Answer

Firewall

Answer

Hub

Answer

Router

Answer

Network Interface Card

Question 34

Which of the following describes the main purpose of a GUI (Graphical User Interface) compared to a CLI (Command Line Interface)?

Accepted Answer

A GUI allows users to interact with the computer using icons and menus, making it more intuitive for beginners.

Answer

A GUI is mainly used by professional programmers because it allows for faster script execution.

Answer

A GUI uses significantly less system memory and processing power than a CLI.

Answer

A GUI requires the user to type specific commands in a strict syntax to perform tasks.

Question 35

Which of the following describes the function of an 'Actuator' in a microprocessor-controlled system?

Accepted Answer

It is a physical device that responds to an output signal from a computer to perform a movement or action.

Answer

It is a piece of software used to encrypt data before it is sent over a wireless network.

Answer

It is a component in the CPU that performs mathematical calculations and logical comparisons.

Answer

It is a sensor used to convert physical variables like temperature into digital data for the computer.

Question 36

Which of the following describes the function of a 'Compiler' when used within the context of computer software systems?

Accepted Answer

It translates the entire high-level language program into machine code all at once before the program is executed.

Answer

It is a hardware component used to increase the clock speed of the Central Processing Unit.

Answer

It is a type of application software used specifically for creating and editing high-resolution graphics.

Answer

It translates and executes high-level language instructions one line at a time.

Question 37

Which of the following is a disadvantage of using a Magnetic Ink Character Reader (MICR) specifically in the banking industry for processing cheques?

Accepted Answer

The technology is more expensive to implement than other methods like Barcode scanning and can only recognize a limited number of characters.

Answer

It requires the user to have high-level programming skills to operate the hardware effectively.

Answer

It is much slower at processing documents than manual data entry by a human operator.

Answer

The ink used is easily damaged by water or folding, making the data unreadable by the scanner.

Question 38

Which of the following is a direct consequence of a 'Buffered' input/output system in a computer?

Accepted Answer

It allows the CPU to continue with other tasks while a hardware device processes data at a different speed.

Answer

It eliminates the need for any secondary storage devices like Hard Disk Drives.

Answer

It prevents the user from using a Graphical User Interface (GUI) while printing.

Answer

It converts all analog signals directly into machine code without using an ADC.

Question 39

Which of the following describes the purpose and functioning of an ADC (Analogue to Digital Converter) in a microprocessor-controlled greenhouse system?

Accepted Answer

It converts continuous physical signals from sensors into discrete binary data that the microprocessor can understand.

Answer

It increases the voltage of the sensor signal so it can travel longer distances without degradation.

Answer

It converts the digital signals from the microprocessor into physical movements to open windows.

Answer

It acts as a storage device to save the temperature readings over a 24-hour period.

Question 40

In the context of data processing and modeling, which of the following refers to the process of choosing the most appropriate field to be the Primary Key in a database table?

Accepted Answer

Selecting a unique identifier that ensures no two records in the table are identical.

Answer

Selecting the field that contains the longest string of text to ensure data capacity.

Answer

Choosing a field that contains duplicate values to group similar records together.

Answer

Assigning an encrypted password to the table to prevent unauthorized access to the database.

Question 41

Which of the following describes the 'Phishing' method used by criminals to gain unauthorized access to computer systems and personal data?

Accepted Answer

Sending legitimate-looking emails to users to trick them into revealing sensitive information like passwords or credit card details.

Answer

Redirecting a user from a legitimate website to a fraudulent one without their knowledge by infecting the DNS cache.

Answer

Gaining access to a secure building by following an authorized person through a security door.

Answer

Installing software that records every key pressed on a keyboard to steal login credentials.

Question 42

In the context of ICT safety and security, which of the following best describes 'Pharming'?

Accepted Answer

Malicious code is installed on a user's computer or server which redirects the user to a fake website even if they type the correct URL.

Answer

A technique used to crack passwords by trying every possible combination of characters.

Answer

Sending fraudulent emails that appear to be from a legitimate source to steal personal data.

Answer

The use of hardware to record every keystroke made by a computer user.

Question 43

In the context of ICT impact and safety, which of the following best describes the 'Digital Divide'?

Accepted Answer

The gap between people who have easy access to the internet and modern technology and those who do not.

Answer

The physical barrier created by hardware components within a network server.

Answer

The difference in speed between a wireless Wi-Fi connection and a wired Ethernet connection.

Answer

The process of splitting a hard drive into multiple logical sections called partitions.

Question 44

In the context of database modeling, what is the specific purpose of a 'Foreign Key'?

Accepted Answer

To create a link between two tables by referencing the primary key of another table.

Answer

To encrypt data fields so they cannot be read by users in foreign countries.

Answer

To automatically calculate the sum of values within a specific column.

Answer

To act as a unique identifier for every record within its own table.

Question 45

In the context of ICT systems, which of the following describes the 'Validation' process during data entry?

Accepted Answer

A computer check to ensure that the data entered is sensible and reasonable according to a set of rules.

Answer

A process where the user reads through the data on the screen to look for typos or mistakes.

Answer

The method of entering the data twice and comparing the two versions for differences.

Answer

The process of checking that the data entered matches the original source document exactly.

Question 46

Which of the following is an example of a 'Verification' technique used to ensure that data has been entered correctly into a computer system?

Accepted Answer

Double data entry

Answer

Range check

Answer

Format check

Answer

Data type check

Question 47

Which of the following is an example of 'Social Engineering' used to gain unauthorized access to computer systems?

Accepted Answer

Baiting

Answer

Encryption

Answer

Biometrics

Answer

Firewall configuration

Question 48

In the context of ICT systems design, what is the main purpose of 'Direct Changeover' during the implementation phase?

Accepted Answer

The old system is stopped completely and the new system is started immediately.

Answer

Both the old and new systems run simultaneously for a period of time to compare results.

Answer

The new system is introduced in stages, module by module, until the old system is replaced.

Answer

The new system is introduced to one branch of the organization to see how it performs.

Question 49

In the context of database systems (Chapter 13), which of the following refers to a field that uniquely identifies each record in a table and ensures data integrity by preventing duplicate records?

Accepted Answer

Primary Key

Answer

Foreign Key

Answer

Composite Key

Answer

Candidate Key

Question 50

When designing a data entry form (Chapter 12), which validation check is most appropriate to ensure that a student's mark is between 0 and 100 inclusive?

Accepted Answer

Range check

Answer

Format check

Answer

Length check

Answer

Presence check

Question 51

In the context of file management and data processing (Chapter 11), which of the following is an advantage of using a 'back-up' of a file?

Accepted Answer

It allows for the restoration of data if the original file is lost or corrupted.

Answer

It reduces the amount of storage space required on a hard drive.

Answer

It automatically corrects errors found in the original document.

Answer

It prevents unauthorized users from accessing the live data.

Question 52

Which of the following describes the 'Analysis' stage of the Systems Life Cycle (Chapter 11) when a systems analyst determines the requirements of a new system?

Accepted Answer

Examining the current system and identifying user requirements through interviews and questionnaires

Answer

Writing the code and creating the user interface for the new software

Answer

Correcting bugs and updating the system after it has been installed for several months

Answer

Comparing the old system with the new system to check if it meets the original objectives

Question 53

In the context of Chapter 13 (Databases), what is the primary purpose of creating a relationship between a 'Primary Key' in one table and a 'Foreign Key' in another table?

Accepted Answer

To allow data to be linked across multiple tables to reduce data redundancy

Answer

To automatically calculate the sum of numerical fields in a report

Answer

To increase the speed of the computer's central processing unit

Answer

To encrypt the data so that it cannot be read by unauthorized users

Question 54

During the 'Implementation' stage of the Systems Life Cycle (Chapter 11), which method of changeover involves running the old system and the new system side-by-side for a period of time?

Accepted Answer

Parallel running

Answer

Pilot running

Answer

Direct changeover

Answer

Phased implementation

Question 55

In the context of Chapter 12 (ICT Applications), which type of model is commonly used to predict the outcome of 'what-if' scenarios by using mathematical formulas and variables?

Accepted Answer

Spreadsheet model

Answer

Network model

Answer

Graphics model

Answer

Physical model

Question 56

In the context of the Systems Life Cycle (Chapter 11), which documentation is specifically designed to help a programmer or systems analyst modify or update the system in the future?

Accepted Answer

Technical documentation

Answer

Evaluation report

Answer

Analysis summary

Answer

User documentation

Question 57

In the context of data analysis and databases, which feature allows a user to ensure that only 'Male' or 'Female' can be entered into a specific field to prevent data entry errors?

Accepted Answer

Validation rules

Answer

Mail merge

Answer

Query design

Answer

Data formatting

Question 58

When creating a professional document or presentation in ICT, what is the primary purpose of using 'Master Slides' or 'Corporate House Styles'?

Accepted Answer

To ensure consistency in layout, font, and branding across all pages

Answer

To reduce the file size of the document for easier email transmission

Answer

To automatically check the document for spelling and grammar errors

Answer

To prevent unauthorized users from editing the content of the document

Question 59

In database management, which type of data relationship is most appropriate when linking a 'Customers' table to an 'Orders' table, given that one customer can place multiple orders but each order belongs to only one customer?

Accepted Answer

One-to-many relationship

Answer

Many-to-many relationship

Answer

One-to-one relationship

Answer

Flat-file relationship

Question 60

In the context of document production, which of the following is an example of 'widow' and 'orphan' control?

Accepted Answer

Ensuring a single line of a paragraph does not appear alone at the top or bottom of a page

Answer

Setting a specific margin size to allow for document binding and hole punching

Answer

Automatically checking the document for gender-neutral language

Answer

Using a master page to define the header and footer for all pages

Question 61

In a relational database, which of the following best describes the function of a 'Foreign Key'?

Accepted Answer

A field in one table that refers to the Primary Key in another table to link records

Answer

A field used to encrypt sensitive data when it is sent over an external network

Answer

A unique identifier that ensures every record in the current table is different

Answer

A specific validation rule that prevents duplicate entries within the same table

Question 62

In the context of the IGCSE ICT curriculum for data analysis, which formula would be used to count the number of cells in the range

=A1+A2*2

that contain a value greater than 50?

Accepted Answer

=COUNTIF(A1:A10, ">50")

Answer

=COUNT(A1:A10, ">50")

Answer

=SUMIF(A1:A10, ">50")

Answer

=LOOKUP(50, A1:A10)

Question 63

In the context of document production and mail merge, which of the following describes the 'Data Source'?

Accepted Answer

A file containing the specific information, such as names and addresses, to be inserted into a master document

Answer

A security protocol used to encrypt the document before it is sent via email

Answer

The main document layout that contains placeholders known as merge fields

Answer

The printer settings used to output the final merged letters or envelopes

Question 64

In a database, which of the following is an example of a 'Presence Check' validation rule?

Accepted Answer

Ensuring that a field must not be left empty during data entry

Answer

Checking that a value falls between the range of

=A1+A2*2

and

100

Answer

Confirming that a date entered is not in the future

Answer

Verifying that the data entered contains only letters and no numbers

Related quizzes

Related quizzes