Downloaded from hlayiso.com
SENIOR CERTIFICATE EXAMINATIONS/
NATIONAL SENIOR CERTIFICATE EXAMINATIONS
INFORMATION TECHNOLOGY P2
2021
MARKS: 150
TIME: 3 hours
This question paper consists of 18 pages.
Copyright reserved Please turn over
Skip to contentAll 2022 papers _hlayiso.com_--500d3219-d02f-4c1c-af0e-452a5fe87f3b/v1-bfe5f3f664d3f236ff89/card.webp)





View all





Information Technology Grade 12 P2 NSC June 2022 QP (Eng)
Grade 12 Information Technology Paper 2 question paper from the NSC June Exam 2022 (English), 18 pages. Read online or download the free PDF.
Information Technology · Grade 12 · NSC June Exam · 2022. Question paper, 18 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2022
- Exam period
- NSC June Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 18
- File size
- 407.5 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 18
This exam
NSC June Exam 2022
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P2 2 DBE/2021
SC/NSC
INSTRUCTIONS AND INFORMATION
1. This question paper consists of SIX sections:
SECTION A: Short questions (15)
SECTION B: System Technologies (25)
SECTION C: Communications and Network Technologies (24)
SECTION D: Data and Information Management (27)
SECTION E: Solution Development (25)
SECTION F: Integrated scenario (34)
2. Read ALL the questions carefully.
3. Answer ALL the questions.
4. The mark allocation generally gives an indication of the number of facts/
reasons required.
5. Number the answers correctly according to the numbering system used in this
question paper.
6. Write neatly and legibly.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 3 DBE/2021
SC/NSC
SECTION A: SHORT QUESTIONS
QUESTION 1
1.1 Choose a term from COLUMN B that matches the description in COLUMN A.
Write only the letter (A–R) next to the question numbers (1.1.1 to 1.1.10) in
the ANSWER BOOK, e.g. 1.1.11 S.
COLUMN A COLUMN B
1.1.1 Someone who uses a variety of A internet hoax
tools to plan, structure, create and
maintain website content B intranet
1.1.2 An update that can be downloaded C Bluetooth
to fix a specific bug in software
D spam
1.1.3 The use of social media to spread
false information that seems truthful E adware
1.1.4 A certain amount of high-speed F service pack
memory built into every hard drive to
speed up access to data on a disk G web author
1.1.5 Software that downloads and H RFID
bombards your computer with
advertisements that pop up while I patch
connected to the internet
J rootkit
1.1.6 A standard language used for
querying and manipulating data in a K extranet
database
L SQL
1.1.7 Data capture technology designed
to store more data and to work more M decryption
effectively than barcode systems
N disc cache
1.1.8 An organisation's network which is
accessible to users outside the O HTML
organisation
P WiMAX
1.1.9 A collection of programs designed to
obtain administrator rights to control Q system analyst
a computer for malicious purposes
R VPN
1.1.10 Wireless technology that allows
devices to communicate with each
other over a short distance
(10 x 1) (10)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 4 DBE/2021
SC/NSC
1.2 Give ONE word/term for each of the following descriptions. Write only the
word/term next to the question numbers (1.2.1 to 1.2.5) in the ANSWER
BOOK.
1.2.1 A high-capacity storage device that uses flash memory chips instead
of magnetic metal hard disks (1)
1.2.2 Software that enables an operating system to communicate with a
specific hardware device (1)
1.2.3 The concept of 'renting' software instead of buying a license to use it
forever (1)
1.2.4 A trend whereby separate technologies and functions from multiple
devices are combined into a single multi-purpose device (1)
1.2.5 A text file (max. 4 Kb) used to store customised settings for a
website on your local computer (1)
TOTAL SECTION A: 15
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 5 DBE/2021
SC/NSC
SECTION B: SYSTEM TECHNOLOGIES
QUESTION 2
2.1 Explain why point-to-point connections are used between components that
exchange large amounts of data. (2)
2.2 A CPU is regarded as the 'heart' of a computer.
2.2.1 What is a CPU with four cores called? (1)
2.2.2 Explain why a CPU with more than one core can process a task
faster than a single-core processor. (2)
2.2.3 Give TWO reasons why the cache memory on the CPU speeds up
processing. (2)
2.3 What are the electronic paths that transfer data between components on the
motherboard called? (1)
2.4 Discuss TWO characteristics of RAM. (4)
2.5 State why developers can benefit from using virtualisation. (2)
2.6 Firmware is software found in different devices.
2.6.1 State the purpose of firmware. (1)
2.6.2 Where is firmware located in a device? (1)
2.7 Explain the relationship between the CMOS and the BIOS by referring to the
purpose of EACH. (2)
2.8 You need to be prepared for a situation where your primary hard disk fails and
nothing on your hard disk can be recovered.
List THREE essential things that you should do to ensure that you will be
prepared to rebuild your system after installing a new primary hard disk. (3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 6 DBE/2021
SC/NSC
2.9 Study the following screenshot:
2.9.1 The capacity of the disk is shown in terms of gigabytes. The smallest
storage unit is a bit. How many bits are in ONE byte? (1)
2.9.2 Explain why it is a good idea to make sure that the contents of a
drive is indexed. (2)
2.9.3 Give ONE reason why you will run a disk clean-up utility. (1)
TOTAL SECTION B: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 7 DBE/2021
SC/NSC
SECTION C: COMMUNICATIONS AND NETWORK TECHNOLOGIES
QUESTION 3
3.1 A network is formed when connecting two or more devices to make
communication between the devices possible.
3.1.1 Which LAN standard is commonly used in a cabled network? (1)
3.1.2 Give TWO reasons why a star topology is popular in networks. (2)
3.1.3 Explain why the use of a switch will be an advantage in a network. (2)
3.2 Networks make it possible to transfer data, information and software.
3.2.1 Who is a seeder when downloading files from the internet when
using BitTorrent? (1)
3.2.2 State the difference between the internet and an intranet. (2)
3.3 A company decides that their employees must rather work from home for
health reasons.
3.3.1 Employees will need to have access to their documents stored on
the server at the office.
Name the type of network with which they can access these
documents through the internet. (1)
3.3.2 What is a back door when referring to network security? (2)
3.3.3 One team member said that while working from home, files would
synchronise automatically when saved in online storage.
Explain what is meant by files being synchronised when saved in
this context. (2)
3.4 Search engines, such as Google, are used by many users each day.
3.4.1 Explain the difference between a customised search and a context-
aware search. (2)
3.4.2 Why does a sponsored link affect the results obtained from a search
engine? (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 8 DBE/2021
SC/NSC
3.5 To enable a web page to be interactive, the web page needs to include
specific programming instructions.
3.5.1 Name TWO different scripting languages. (2)
3.5.2 Briefly explain how server-side scripting is implemented to establish
an interactive web page. (2)
3.6 Management of many retail companies has to make informed decisions every
day. State TWO advantages of using a DSS. (2)
3.7 Give ONE reason why the quality of information presented by wikis, such as
Wikipedia, are NOT always reliable. (1)
TOTAL SECTION C: 24
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 9 DBE/2021
SC/NSC
SECTION D: DATA AND INFORMATION MANAGEMENT
QUESTION 4
A database is used at a mall to store details of stores, staff, clients and other
information. A staff member can work at only one store. One of the tables is called
tblStores and has the following table design:
Table: tblStores
Field name Data type Description
StoreName Short Text (30) The name of the store at the mall
NumOfSquareMetres Number (Double) The total number of square metres the
store occupies
RentalAmount Number (Double) The monthly rent for the store
DateOpened Date/Time The date on which the store opened for
the first time
NumYearsOpen Number (Integer) The number of completed years the store
has been doing business at the mall
4.1 The DateOpened field has been selected as a primary key field.
4.1.1 Explain the purpose of a primary key. (1)
4.1.2 Give a reason why using the DateOpened field as a primary key
may be inappropriate. (1)
4.1.3 Recommend a more suitable primary key for the table tblStores,
that could have been included in the tblStores table. (1)
4.2 Normalisation is a term that is commonly used in the context of relational
databases.
4.2.1 Explain the term normalisation. (2)
4.2.2 Why does the inclusion of the NumYearsOpen field violate
normalisation rules? (2)
4.3 Data needs to be validated to ensure that we have quality data.
Name TWO validation tests that can be performed on the DateOpened field
when data is entered into the field. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 10 DBE/2021
SC/NSC
4.4 A table, tblStaff, was created to save the information of the staff members of
each store. Use the ERD diagram below to answer QUESTION 4.4.1 and
QUESTION 4.4.2.
STORE STAFF
4.4.1 Describe the relationship between the tables using a suitable action
verb. (1)
4.4.2 What is the type of relationship between the STORE entity and the
STAFF entity? Choose the answer and write only the letter (A–C)
next to the question number, e.g. 4.4.2 D.
A. Many-to-one relationship
B. One-to-many relationship
C. Many-to-many relationship (1)
4.5 Indicate whether the following statements are TRUE or FALSE. Write only
'true' or 'false' next to the question numbers (4.5.1 to 4.5.5) in the ANSWER
BOOK.
4.5.1 A primary key and a foreign key used to establish a relationship
between two tables must have the exact same field name in both
tables. (1)
4.5.2 Data saved in a foreign key field in a table can contain duplicates. (1)
4.5.3 Referential integrity can be applied in a single table. (1)
4.5.4 Database redundancy can lead to database anomalies. (1)
4.5.5 An advantage of data independence is that multiple applications can
interface to the same data, as the physical structure of the database
is independent of the application. (1)
4.6 Most chain stores at malls use data warehousing, which provide storage for
large amounts of data. Records that are outdated in the current database
need to be moved to the data warehouse.
Give TWO reasons why the outdated records need to be transformed before it
is combined with the data in the data warehouse. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 11 DBE/2021
SC/NSC
4.7 Transactions in a database management system include deleting records.
When a record is deleted, it is only flagged as deleted.
Why are these records flagged as deleted and not removed from the
database? (1)
4.8 State TWO potential problems in using a single centralised database serving
a large number of connected users and requests. (2)
4.9 The mall needs to take measures to ensure that the information stored in the
database will not be compromised.
State TWO ways of preventing an SQL injection attack on the database by
hackers. (2)
4.10 Online data collection takes place at the pay point in a supermarket.
4.10.1 Define the term online data collection. (2)
4.10.2 Give ONE example of online data collection at the pay point in a
supermarket AND explain how the data can be used to the benefit of
the supermarket. (2)
TOTAL SECTION D: 27
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 12 DBE/2021
SC/NSC
SECTION E: SOLUTION DEVELOPMENT
QUESTION 5
5.1 An algorithm is a step by step breakdown to solving a problem.
5.1.1 Name ONE technique/tool/diagram that can be used to represent an
algorithm. (1)
5.1.2 Give ONE reason why algorithms should NOT be language specific. (1)
5.2 Study the following Delphi code and answer the questions that follow:
5 Procedure TForm1.btnCalculateClick(Sender: TObject);
6 Var
7 iSum:integer;
8 begin
9 iSum := 5+7;
10 displayAnswer;
11 end;
12
13 Procedure TForm1.displayAnswer;
14 Var
15 iSum:integer;
16 begin
17 ShowMessage('The sum is: '+ intToStr(iSum));
18 end;
5.2.1 What can be done to make the code in the example above more
readable? (1)
5.2.2 When the program is executed, the output displayed in line 17 will
be 0.
(a) What type of error is this? (1)
(b) Give TWO reasons why the sum is displayed as 0, even
though the sum is calculated correctly in line 9. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 13 DBE/2021
SC/NSC
5.3 The following incomplete Delphi solution is provided for a problem that should
display 15 randomly generated odd numbers in the range 10 to 40 (inclusive):
1 iCountOdd := 0;
2 While iCountOdd < 15 do
3 Begin
4
5 iRandom := …………
6 if (………) then
7 Begin
8
9 showMessage(IntToStr(iRandom));
10 End;
11 End;
12
5.3.1 Line 5 needs to be completed. Write Delphi code to generate a
random number in the range 10 to 40. (1)
5.3.2 Select the correct option for EACH of the following questions and
write down only the CORRECT answer/option in the ANSWER
BOOK:
(a) The IF statement to determine if the randomly generated
number is an odd number will be …
(i) if (iRandom DIV 2 = 1) then
(ii) if (iRandom MOD 2 = 0) then
(iii) if (iRandom MOD 2 <> 0) then (1)
(b) The statement inc(iCountOdd) should be added to the code
above.
Choose the line number for the correct position of the
statement:
(i) 4
(ii) 8
(iii) 12 (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 14 DBE/2021
SC/NSC
(c) Which ONE of the following will provide the correct solution if
the While statement in the given code on the previous page
must be replaced by a Repeat..Until statement:
(i) Repeat
…
Until iCountOdd > 15;
(ii) Repeat
…
Until iCountOdd >= 14;
(iii) Repeat
…
Until iCountOdd = 15; (1)
5.4 Write down the most suitable data types for variables X and Y in the following
statements where the data type of the Number variable is not known:
5.4.1 X := Floor(80/12*2); (1)
5.4.2 Y := Sqr(Sqrt(Number)); (1)
5.5 Consider the following UML-diagram and answer the questions that follow:
TStaff
- StaffID
- StaffName
- StaffSurname
+ ContactNumber
+ DateAppointed
+ create;
+ getStaffID:String;
+ setContactNumber(sContactNumber:String);
+ isValidDate(iDay, iMonth, iYear:integer): boolean;
+ calcYearsOfExp:integer;
5.5.1 Differentiate between an accessor method and a mutator method. (2)
5.5.2 (a) What does the positive sign (+) and the negative sign (-) refer
to in the UML diagram? (1)
(b) Refer to the answer to QUESTION 5.5.2(a) and motivate why
instance fields/attributes should rather be declared with the
negative sign (-) rather than with the positive sign (+). (1)
5.5.3 Identify ONE procedure in the UML diagram above. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 15 DBE/2021
SC/NSC
5.6 The Fibonacci sequence is a series of numbers: 1, 1, 2, 3, 5, 8, 13, 21, 34, ...
The next number in the series is calculated by adding up the two preceding
numbers.
The following incomplete algorithm has been provided:
The number of terms/numbers in the sequence must be entered and the
series displayed.
input iNumTerms //number of terms in sequence
iTerm1 1;
iTerm2 1;
if iNumTerms = 1 then
sLine iTerm1
display sLine
else if iNumTerms = 2 then
sLine iTerm1 + ' ' + iTerm2
display sLine
else
...
...
...
...
...
...
Complete the algorithm above to display the required output. (8)
TOTAL SECTION E: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 16 DBE/2021
SC/NSC
SECTION F: INTEGRATED SCENARIO
QUESTION 6
A new shopping mall has been built in your area. The availability of computer services
and Wi-Fi to businesses and visitors are one of the most important issues to consider.
6.1 The diagram below is an example of a WLAN. Wi-Fi access points have been
placed at various places in the shopping mall.
6.1.1 What medium is used to transfer Wi-Fi data? (1)
6.1.2 Give TWO reasons why there may be a need for many access
points in the network environment of the mall. (2)
6.2 The local shopping mall allows you to download an app to make navigating
the mall easy and it can help customers to have a more enjoyable visit to the
mall.
6.2.1 Which type of device will most likely be used to run this app? (1)
6.2.2 What does the term appification of the Web refer to? (2)
6.2.3 You are requested to improve the app by applying defensive
programming.
What is defensive programming? (2)
6.2.4 Briefly describe TWO examples of defensive programming
techniques. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 17 DBE/2021
SC/NSC
6.3 Transactions are mostly done electronically. Any data that is sent over a
network passes through different nodes. Encryption is necessary to ensure
that all transactions are secure.
6.3.1 Name an encryption protocol commonly used to encrypt private data
that is sent over the internet. (1)
6.3.2 Briefly explain how public key encryption works. (3)
6.4 GPS and location-based computing are terms that are often used together.
6.4.1 Define location-based computing. (2)
6.4.1
6.4.2 Give an example of the use of location-based computing in a mall
environment. (1)
6.5 Staff in different shops must be made aware of cybercrime, such as hacking
and DDoS attacks.
6.5.1 Explain the difference between a white hat hacker
and a black hat hacker.
(2)
6.5.2 Explain the effect of a DDoS attack. (1)
6.5.3 The effects of cybercrime are largely the same as those of normal
crime.
Name TWO negative effects that cybercrime can have on
businesses. (2)
6.6 MyVSpace is a virtual office space in the mall.
Define the term virtual office. (2)
6.7 During the Covid-19 pandemic, employees of a law firm were requested to
work from home. The employees need to have a Google Meet session at
09:00 every work day. These meetings must be recorded.
6.7.1 What is the term used to indicate that an employee uses technology
to work from home? (1)
6.7.2 All employees have been provided with a laptop, data and software
applications to attend the meetings. What other hardware device
would you recommend to be used in a home environment during
these meetings, and why? (2)
6.7.3 Name ONE video conferencing platform, other than Google Meet,
that can be used for the meetings. (1)
6.7.4 Give ONE example of a cloud storage space/service that could be
used for saving the records of the meetings. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 18 DBE/2021
SC/NSC
6.8 Augmented reality and virtual reality are two of the most promising
technologies available to mobile app developers.
6.8.1 Explain the difference between virtual reality and augmented reality. (2)
6.8.2 How can the app improve the shopping experience at the mall by
using augmented reality? (1)
6.8.3 Augmented reality is made possible by fusing data from multiple
sensors. Name TWO applicable sensors available on a mobile
device. (2)
TOTAL SECTION F: 34
GRAND TOTAL: 150
Copyright reserved
Study this subject
Recommended for this subject
_hlayiso.com_--500d3219-d02f-4c1c-af0e-452a5fe87f3b/v1-bfe5f3f664d3f236ff89/card.webp)
Question paper
Information Technology Grade 12 P2 NSC June 2022 QP (Afr)

Question paper
Information Technology Grade 12 P2 Eastern Cape Mock 2022 QP

Question paper
Information Technology Grade 12 P2 Eastern Cape Mock 2022 QP

Question paper
Information Technology Grade 12 P2 NSC November 2022 QP

Question paper
Information Technology Grade 12 P2 NSC June 2018 QP (Afr)

Memorandum
Information Technology Grade 12 P2 NSC June 2018 Memo (Afr)
More from Grade 12 Information Technology

Memorandum
Information Technology Grade 12 P1 NSC June 2025 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2024 Memo (Eng)

Memorandum
Information Technology Grade 12 P2 2024 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2023 Memo (Afr)

Memorandum
Information Technology Grade 12 P2 2023 Memo (Afr)

Memorandum