Font size
WorksheetsSECTION A: QUESTION 1 - SHORT QUESTIONS
Total questions: 85
Worksheet time: 43mins
Give the best term for each of the descriptions given below: 1.1.1 The law protecting the intellectual property of a developer.
Copyright
Patent
Trademark
Trade Secret
An image used as a code, which acts as a link to a form, document or website.
QR code
Barcode
Captcha
Watermark
Connection and communication of different types of devices over the internet.
Internet of Things (IoT)
Cloud Computing
Blockchain
Virtual Reality
Give the best term for each of the descriptions given below: 1.1.4 Watching or listening to the content of files on the internet without saving it.
Streaming
Downloading
Uploading
Browsing
A hardware component that provides a desktop computer with electricity and also controls the electrical current (amps) distributed to the different hardware components within the computer.
Power supply unit (PSU)
Graphics card (GPU)
Hard disk drive (HDD)
Motherboard
Software where the code is available to be used and/or changed if the user has the knowledge to do so.
Open source software
Proprietary software
Shareware
Freeware
A type of network involving various devices and usually controlled by the individual's mobile device.
Personal Area Network (PAN)
Wide Area Network (WAN)
Metropolitan Area Network (MAN)
Local Area Network (LAN)
When devices are connected to the computer, they are identified by the operating system (OS) and immediately available for use as the OS has the drivers installed.
Plug and Play
Hot Swapping
Safe Mode
BIOS Boot
The number of BITS in a BYTE.
8
4
16
10
The coding error when we refer to a working/running program providing incorrect output. This is usually due to incorrect order of statements or incorrect formula used (typing errors in formulae).
Logic error
Syntax error
Runtime error
Compilation error
What is the main purpose of the CPU-Z application?
To play games
To show information about the hardware configuration of your computer
To edit documents
To browse the internet
What compulsory action must be completed before the installation of CPU-Z can proceed?
You must accept the license agreement.
You must restart your computer.
You must uninstall previous versions of CPU-Z.
You must connect to the internet.
Explain what is meant by freeware.
Freeware is software that is available for use at no cost.
Freeware is software that requires a monthly subscription.
Freeware is software that is only available to government organizations.
Freeware is software that is used exclusively for educational purposes.
It is compulsory to adhere to the license agreement (Figure 3) even if the application is freeware because:
the license agreement is a legal contract that must be followed regardless of the application's cost.
freeware applications do not have any rules or restrictions.
license agreements only apply to paid software.
ignoring the license agreement is allowed for freeware.
Distinguish between a multi-user license and a site license.
A multi-user license allows a specific number of users to use the software, while a site license allows all users at a particular location or organization to use the software.
A multi-user license allows unlimited users across multiple organizations, while a site license restricts usage to a single user.
A multi-user license is only for educational institutions, while a site license is for commercial businesses only.
A multi-user license is a temporary license, while a site license is permanent.
Define the meaning of cores when referring to a CPU.
Cores are individual processing units within a CPU that can execute instructions independently.
Cores are the amount of memory available in a CPU.
Cores are the external devices connected to a CPU.
Cores are the speed at which a CPU operates.
How many cores are on this Intel i7 processor, according to Figure 3?
4 cores
2 cores
6 cores
8 cores
State the function of cache on the CPU.
Cache stores frequently used data and instructions to speed up processing and reduce access time.
Cache increases the size of the CPU to allow more programs to run simultaneously.
Cache is used to permanently store all files and applications on the computer.
Cache is responsible for generating power for the CPU to function.
Cache memory can be used to store frequently accessed data in web browsers. How is cache memory used in this example?
It stores web page data to speed up loading times on future visits.
It permanently saves all files downloaded from the internet.
It encrypts all data sent over the internet for security.
It deletes all cookies and browsing history automatically.
A device that is 'ergonomically designed' is one that:
is designed to fit the user's body and reduce discomfort or injury
is made from the most expensive materials
is designed only for aesthetic appeal
is intended for use only by professionals
Name the condition some people suffer from, which led to the study of ergonomically designed peripherals, such as a mouse.
Carpal tunnel syndrome.
Asthma.
Diabetes.
Hypertension.
Which of the following is NOT a reason, aside from internet access, why computer ownership has become so prevalent in the current century?
Increased need for digital skills in education and work
Growth of digital entertainment and media consumption
Advancements in computer affordability and accessibility
Widespread availability of high-speed internet
Application software is designed to perform specific tasks for users, while system software manages and controls computer hardware. Which of the following best describes the dependency between application software and system software?
Application software depends on system software to function properly.
System software depends on application software to run the hardware.
Both types of software operate independently with no dependencies.
Application software manages hardware directly without system software.
Modular design of computers refers to the practice of building computers from separate, interchangeable components. Which of the following best explains why modular design is beneficial?
It allows for easy upgrades and repairs by replacing individual parts.
It makes computers more expensive and harder to repair.
It prevents users from customizing their computers.
It requires all components to be permanently fixed together.
Conventional hard drives have not yet completely been replaced with solid-state drives (SSDs) because:
SSDs are still more expensive than conventional hard drives for large storage capacities.
SSDs are slower than conventional hard drives.
Conventional hard drives are more durable than SSDs.
SSDs are not compatible with most computers.
2.9.2 Select TWO benefits associated with an SSD.
Faster data access and lower power consumption
Larger physical size and slower speed
Requires frequent defragmentation and is noisier
More moving parts and higher failure rate
2.10.1 Select TWO considerations when making backups.
Frequency of backups and storage location
Type of printer used and screen resolution
Font style and color scheme
Monitor size and keyboard layout
Cloud synchronisation is defined as:
The process of keeping data consistent across multiple devices using cloud storage.
A method of increasing internet speed by using multiple networks.
A technique for compressing files before uploading to the cloud.
A way to protect data by encrypting it before cloud upload.
Which TWO security actions/strategies can a company apply to verify that you are authentic when logging onto a branch network?
Implement two-factor authentication and use digital certificates.
Allow guest access and disable firewalls.
Share passwords with all employees and use default credentials.
Disable encryption and allow open Wi-Fi access.
Due to the volume of emails you receive daily, you're susceptible to various security risks. List, then define/explain in a table THREE of the most common email security risks. For each risk, suggest ONE protective measure you can take to mitigate the risk.
Risk 1: Phishing | Explain/define: Fraudulent attempt to obtain sensitive information | Protective measure: Use email filtering and user training Risk 2: Malware | Explain/define: Malicious software sent via email attachments | Protective measure: Use antivirus software Risk 3: Spam | Explain/define: Unsolicited bulk emails | Protective measure: Use spam filters
Risk 1: Encryption | Explain/define: Securing emails with codes | Protective measure: Use strong passwords Risk 2: Social Engineering | Explain/define: Manipulating people to give up confidential info | Protective measure: Ignore all unknown emails Risk 3: Data Loss | Explain/define: Losing important files | Protective measure: Never back up data
Risk 1: Phishing | Explain/define: Sending newsletters to users | Protective measure: Use weak passwords Risk 2: Malware | Explain/define: Legitimate software updates | Protective measure: Disable antivirus software Risk 3: Spam | Explain/define: Important business emails | Protective measure: Mark all as read
Risk 1: Spoofing | Explain/define: Sending emails from a fake address | Protective measure: Share passwords openly Risk 2: Ransomware | Explain/define: Encrypting files for ransom | Protective measure: Pay the ransom Risk 3: Adware | Explain/define: Displaying ads in emails | Protective measure: Click on all ads
The most time and cost-efficient way to conduct a workshop for all managers at all branches is:
Conducting a virtual workshop via video conferencing
Organizing separate workshops at each branch
Arranging an offsite workshop for all managers
Sending printed workshop materials to each branch
The protocol that made the answer in 3.3.1 possible is:
HTTP
FTP
SMTP
SSH
A key difference between a LAN and a WAN, apart from the size of the area covered, is:
LANs are typically owned and managed by a single organization, while WANs often connect multiple organizations and use public or leased communication links.
LANs use only wireless connections, while WANs use only wired connections.
LANs do not require any network devices, while WANs require only routers.
LANs can connect devices across countries, while WANs are limited to a single building.
A router in networking is defined as:
A device that forwards data packets between computer networks.
A device that stores large amounts of data for backup.
A device that only connects wireless devices to the internet.
A device that converts digital signals to analog signals.
A Cloud Server in networking is defined as:
A virtual server that is hosted and delivered through a cloud computing platform.
A physical server located in a local office network.
A device used only for printing documents over a network.
A type of cable used to connect computers in a network.
Bandwidth in networking is defined as:
The maximum rate of data transfer across a given path
The physical length of a network cable
The number of devices connected to a network
The type of protocol used in communication
Many organisations, including companies and schools, often implement Local Area Networks (LANs) that span a large area and are divided into smaller subnetworks. These subnetworks connect to a central device. In a star topology, all devices connect to this central device.
Switch (or Hub)
Router
Repeater
Bridge
Name another network topology (besides star).
Bus topology
Centralized topology
Linear topology
Hierarchical topology
Give TWO reasons why fibre optical cable will be used as communication medium of the backbone.
1. High data transmission speed 2. Immunity to electromagnetic interference (Other valid answers: Long distance transmission, High bandwidth)
1. Low installation cost 2. Easy to tap into the cable
1. Susceptibility to electromagnetic interference 2. Low bandwidth
1. Slow data transmission speed 2. Short distance transmission
State TWO reasons how utilising the Cloud can assist in this regard.
1. Enables real-time collaboration and access to files from anywhere 2. Automatic backup and version control
1. Increases hardware requirements and manual updates 2. Limits access to files outside the office
1. Reduces data security and increases downtime 2. Requires constant physical backups
1. Slows down file sharing and restricts user permissions 2. Disables remote access
This distribution model will benefit their clients because:
It provides faster and more efficient delivery of products.
It increases the cost for clients.
It limits the variety of products available to clients.
It reduces the quality of customer service.
Data warehousing is related to data mining and ChatGPT in which of the following ways?
Data warehousing stores large volumes of data, which can be analyzed using data mining techniques, and insights can be used to enhance AI models like ChatGPT.
Data warehousing is used to train ChatGPT directly without any data mining.
Data mining replaces the need for data warehousing in AI applications like ChatGPT.
ChatGPT is used to create data warehouses for data mining.
Modern robotics is an example of AI because:
it uses intelligent algorithms to perform tasks autonomously.
it only follows simple mechanical instructions.
it does not require any programming.
it operates without any sensors or data input.
What is the field name in the CustomerTbl that stores the cell phone number?
CellNumber
PhoneID
MobileContact
ContactName
What data type is used for the CustomerNameSurname field in the CustomerTbl?
Short Text
Number
Date/Time
Currency
What is stored in the CustomerSA_ID field in the CustomerTbl?
SA ID number - 13 Digits
Customer's phone number
Customer's email address
Customer's home address
How many characters are allowed in the CustomerTitle field in the CustomerTbl?
5 Characters
10 Characters
15 Characters
20 Characters
Which field in the OrdersTbl stores the order number?
OrderNumber
OrderDate
CustomerID
TotalAmount
What is the data type for the PrintCount field in the OrdersTbl?
Number
Text
Date/Time
Currency
Which field in the OrdersTbl indicates whether the item to be printed is a picture or a document?
PrintType
OrderDate
CustomerID
Quantity
What does the PrintFileName field in the OrdersTbl represent?
Document name to be printed
Order creation date
Customer's email address
Order total amount
The data type used for the cell phone (CellNumber) and SA ID fields (CustomerSA_ID) should be chosen carefully. Which of the following is the correct reason for selecting the appropriate data type for these fields?
They should be stored as strings because they may contain leading zeros and are not used for calculations.
They should be stored as integers because they are numbers.
They should be stored as floating-point numbers to handle large values.
They should be stored as dates to ensure uniqueness.
The way in which the name and surname field is saved is correct. Motivate your answer.
Yes, because the fields are separated and stored appropriately.
No, because the fields are combined into one field.
No, because the surname is saved before the name.
No, because the fields are not saved at all.
Which fields are used to draw the relationship between the two tables?
Primary key of the first table and foreign key of the second table
Primary key of both tables
Foreign key of both tables
Any random fields from both tables
How do we refer to the CustomerSAID field in association with the table, if the cell phone number is the primary key?
CustomerSAID would be referred to as an alternate key or candidate key.
CustomerSAID would be referred to as a foreign key.
CustomerSAID would be referred to as a composite key.
CustomerSAID would be referred to as a surrogate key.
Which of the following are two different reports that the company can generate from the data in the tables?
Sales report and inventory report
Weather report and sports report
Travel report and movie report
Fashion report and gardening report
Write an SQL statement to count the number of prints made from the different print sizes (PrintSize field). Use a descriptive heading for the answer field.
SELECT PrintSize, COUNT(*) AS NumberOfPrints FROM Prints GROUP BY PrintSize;
SELECT COUNT(PrintSize) AS NumberOfPrints FROM Prints;
SELECT PrintSize, SUM(*) AS NumberOfPrints FROM Prints GROUP BY PrintSize;
SELECT PrintSize, COUNT(*) FROM Prints;
Which Delphi component would best be suited to indicate the number of copies to be printed?
A SpinEdit component.
A Label component.
A Button component.
A ProgressBar component.
Which interface design allows A4 and A5 print sizes to be available only for the 'Document' print type, and Standard and Jumbo print sizes to be available only for the 'Picture' print type?
Use a dropdown for PrintType that dynamically updates the PrintSize dropdown to show only valid sizes for the selected type.
Allow all print sizes to be selectable regardless of PrintType.
Use checkboxes for both PrintType and PrintSize, allowing any combination.
Display all print sizes at all times, but disable the PrintType selection after choosing a size.
An example of when you would create a one-to-one relationship between two tables is:
When storing additional user profile details in a separate table linked to the main user table.
When linking multiple orders to a single customer.
When associating products with multiple categories.
When recording multiple addresses for a single employee.
Explain what a distributed database is.
A distributed database is a database in which data is stored across different physical locations, which may be connected via a network.
A distributed database is a database that only stores data on a single computer.
A distributed database is a type of database that does not require any network connection.
A distributed database is a database that only stores unstructured data.
Many businesses use distributed databases for data storage. Give TWO benefits of using the distributed databases.
1. Improved reliability and availability. 2. Faster data access for users in different locations.
1. Increased hardware costs. 2. More complex user interfaces.
1. Reduced data security. 2. Slower data processing.
1. Limited scalability. 2. Centralized data control.
Use a trace table with the following headings to test the logic of the algorithm above. (Complete the trace table provided on the tear-off sheet at the end of this paper.)
line 1: sData = file, sNew = , i = , If i<=4 = , output = line 2: sData = , sNew = "", i = , If i<=4 = , output =
line 1: sData = , sNew = file, i = , If i<=4 = , output = line 2: sData = , sNew = , i = "", If i<=4 = , output =
line 1: sData = , sNew = , i = file, If i<=4 = , output = line 2: sData = , sNew = , i = , If i<=4 = "", output =
line 1: sData = , sNew = , i = , If i<=4 = file, output = line 2: sData = , sNew = , i = , If i<=4 = , output = ""
5.1.2 The algorithm's correctness should be evaluated, and an improvement or correction should be suggested if required.
The algorithm should be checked for correctness and improved if necessary.
The algorithm should be ignored regardless of correctness.
The algorithm should be accepted without evaluation.
The algorithm should be replaced without checking correctness.
5.2 Each user needs a strong password. One of the requirements for a strong password is that it may not contain your name within it. Example: if your name is Ben the following are wrong: 56#BEN!! or KUJbEn98& are correct: 76B*en76@% or oiuoNEB(*2. Which Delphi statement can be used to test if a name is contained in the password? (Use sName and sPassword as variables)
if Pos(sName, sPassword) > 0 then
if sPassword = sName then
if Length(sPassword) < Length(sName) then
if sName in sPassword then
An algorithm to test if a password meets the requirement of containing at least 1 uppercase letter and at least 2 digits should check for which of the following?
The password has at least one uppercase letter and at least two digits.
The password has only lowercase letters and at least two digits.
The password has at least one uppercase letter and no digits.
The password has at least two uppercase letters and at least one digit.
Which of the following best represents the attributes and constructor parameters for the UML class diagram of the TOrder object, based on the given order details?
Order number (String), Cell number (String), Number of copies (Integer), Print size (String), Type of document (String), File name (String); Constructor receives all except date of order as parameters.
Order number (Integer), Cell number (Integer), Date of order (String), Number of copies (String), Print size (Integer), Type of document (Integer), File name (Integer); Constructor receives all as parameters.
Order number (String), Cell number (String), Date of order (String), Number of copies (String), Print size (String), Type of document (String), File name (String); Constructor receives only order number as parameter.
Order number (String), Cell number (String), Number of copies (Integer), Print size (String), Type of document (String), File name (String); Constructor receives only file name as parameter.
The purpose of a mutator method is to: (A) Retrieve the value of an object's attribute and is it a function or procedure? (B) Modify the value of an object's attribute and is it a function or procedure? (C) Create a new object and is it a function or procedure? (D) Delete an object and is it a function or procedure?
Retrieve the value of an object's attribute and is it a function or procedure?
Modify the value of an object's attribute and is it a function or procedure?
Create a new object and is it a function or procedure?
Delete an object and is it a function or procedure?
Select TWO benefits of OOP from the options below.
Code reusability and easier maintenance
Increased code complexity and redundancy
Limited scalability and poor data security
Slower development and less flexibility
The use of RFID tags is more expensive because:
the tags and readers are costly to produce and implement.
they are made of paper and ink.
they require no technology to operate.
they are used only for decorative purposes.
Select TWO reasons why a shop manager should invest in RFID tags to replace barcodes.
RFID tags allow for faster inventory tracking and reduce human error.
RFID tags are more durable and can be read without direct line of sight.
RFID tags are less expensive than barcodes in all cases.
RFID tags require more manual labor than barcodes.
What is 'location-based computing' and how can it be used to benefit a shop's turnover? Select the correct answer.
It uses customer location data to send targeted promotions and improve in-store experience, increasing sales and customer engagement.
It refers to computing only in fixed locations, which limits customer interaction and reduces sales.
It is a method of tracking employee attendance using GPS, which does not affect shop turnover.
It is a system for managing shop inventory remotely, unrelated to customer location or sales.
Name the term for techniques of improving a website's ranking in search results.
Search Engine Optimization (SEO)
Content Management System (CMS)
Pay Per Click (PPC)
User Experience Design (UXD)
Globalisation can be understood as:
the process of increased interconnectedness and integration among countries worldwide
the restriction of trade and communication between nations
the exclusive focus on local cultures and traditions
the elimination of international cooperation
Which of the following are examples of how globalisation is experienced?
International trade, cultural exchange, and global communication
Local farming, traditional crafts, and regional dialects
Isolationism, protectionism, and self-sufficiency
National holidays, local cuisine, and domestic travel
Supply the missing part (word, term or partial phrase) for Wired Communication as indicated by the letter (a).
Copper cables or fiber optic cables
Wireless signals
Satellite links
Bluetooth connections
Supply the missing part (word, term or partial phrase) for Wireless Communication as indicated by the letter (b).
coverage area
frequency band
data rate
modulation type
Supply the missing part (word, term or partial phrase) for Wireless Communication as indicated by the letter (c).
encryption
amplification
modulation
multiplexing
Supply the missing part (word, term or partial phrase) for Wired Communication as indicated by the letter (d).
Less susceptible to interference
Requires no physical medium
Highly affected by weather
Prone to signal fading
The common name for the ‘Wireless Device’ as indicated in Figure 4 is:
Router
Printer
Monitor
Keyboard
State the unit which is used to measure internet speed.
Megabits per second (Mbps)
Joules
Hertz
Celsius
What is it used for and how does it work?
It is used for a specific purpose and works by following a defined process.
It is used for decoration and works automatically.
It is used for entertainment and works by playing music.
It is used for storage and works by keeping items safe.
The restriction in Web 1 that led to the development of Web 2 was:
Limited interactivity and static content
High level of user-generated content
Advanced social networking features
Real-time collaboration tools
6.8.2 The main feature found in Web 3 is:
Decentralization
Centralized control
Limited user interaction
Static web pages
A software patch is:
an update that fixes bugs or security issues in software, such as a Windows update that addresses vulnerabilities.
a completely new version of a software program.
a hardware component added to a computer system.
a type of computer virus.
