Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
INFORMATION TECHNOLOGY P2
NOVEMBER 2022
MARKS: 150
TIME: 3 hours
This question paper consists of 16 pages.
Copyright reserved Please turn over
Skip to contentAll 2022 papers 


_hlayiso.com_--7454979b-cba2-4b39-a884-69e6b1c0f5c6/v1-3f9dc1675d92ae7768e5/card.webp)
_hlayiso.com_--500d3219-d02f-4c1c-af0e-452a5fe87f3b/v1-bfe5f3f664d3f236ff89/card.webp)

View all





Information Technology Grade 12 P2 NSC November 2022 QP
Grade 12 Information Technology Paper 2 question paper from the NSC November Exam 2022 (English), 16 pages. Read online or download the free PDF.
Information Technology · Grade 12 · NSC November Exam · 2022. Question paper, 16 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2022
- Exam period
- NSC November Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 16
- File size
- 601.8 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 16
This exam
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P2 2 DBE/November 2022
NSC
INSTRUCTIONS AND INFORMATION
1. This question paper consists of SIX sections:
SECTION A: Short Questions (15)
SECTION B: Systems Technologies (25)
SECTION C: Communication and Network Technologies (25)
SECTION D: Data and Information Management (25)
SECTION E: Solution Development (20)
SECTION F: Integrated Scenario (40)
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/November 2022
NSC
SECTION A: SHORT QUESTIONS
QUESTION 1
1.1 Various options are provided as possible answers to the following questions.
Choose the answer and write only the letter (A–D) next to the question
numbers (1.1.1 to 1.1.5) in the ANSWER BOOK, e.g. 1.1.6 D.
1.1.1 A process where a single program is broken up into multiple parts
that can be processed simultaneously and independently:
A Multitasking
B Multiprocessing
C Multithreading
D Multiflow (1)
1.1.2 The following is a type of volatile memory:
A Solid-state disk
B Disk cache
C Flash disk
D Blue-ray disk (1)
1.1.3 A … is a file which includes visual media and is made available for
download.
A Media repository
B RSS feed
C Vodcast
D Broadcast (1)
1.1.4 A programming language used exclusively for manipulating data in a
database:
A SQL
B AJAX
C DELPHI
D PHP (1)
1.1.5 Given the following statement:
iAnswer := 12 + 4/2 * 2/(9 MOD 2);
The value of iAnswer will be …
A 12
B 13
C Error
D 16 (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 4 DBE/November 2022
NSC
1.2 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.2.1 to 1.2.10) in
the ANSWER BOOK, e.g. 1.2.11 S.
COLUMN A COLUMN B
1.2.1 Any activity regarding creating, editing A copyright
or deleting of data managed by a
database management system B user rights
(DBMS)
C scalability
1.2.2 A data structure that stores a set of
values of the same data type D artificial intelligence
1.2.3 A method used to bypass the normal E driver
authentication procedure on a network
in order to obtain unauthorised access F AUP
1.2.4 A programming language that can be G phishing
used to add interactivity to a website
H transaction
1.2.5 Protection for any published work that
helps to prevent that work from being I JavaScript
used without permission from the
author J backdoor
1.2.6 The process of having sets of the K array
same data file on separate devices
automatically being updated to the L modulator
latest copy
M string
1.2.7 A program that enables the operating
system to control a device N convergence
1.2.8 Advanced settings for shared files, O synchronisation
used by the server administrator to
manage the type of access to the files P C++
1.2.9 A field of computer science that usually Q class
involves data analytics, machine
learning and rule-based decision- R Python
making to create the ability of
automated decision-making
1.2.10 The ability of a system to increase or
decrease its resources depending on
the number of users
(10 x 1) (10)
TOTAL SECTION A: 15
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 5 DBE/November 2022
NSC
SECTION B: SYSTEMS TECHNOLOGIES
QUESTION 2
2.1 The local recycling club runs a gaming centre to raise funds. You have been
tasked with the buying of computers for online gaming purposes.
2.1.1 Computers are built with slots that hold the RAM.
(a) Give the acronym for the slots that hold the RAM. (1)
(b) What is the base unit of measurement used to measure the
size of the RAM? (1)
2.1.2 Give TWO hardware specifications that should be considered when
choosing a GPU. (2)
2.1.3 A motherboard houses and connects the components of a computer.
(a) What is the component on the motherboard called that houses
the CPU? (1)
(b) Explain why a point-to-point connection is used to connect the
CPU to the RAM, rather than a bus as used for other
components. (2)
2.2 A specific operating system has been recommended for use at the centre.
2.2.1 Define the term operating system. (1)
2.2.2 State any TWO functions of an operating system. (2)
2.3 The CPU is dependent on the RAM to process applications.
2.3.1 What is the memory called that is created when the operating
system reserves a portion of the storage to be used as memory
(RAM)? (1)
2.3.2 Explain how the process of artificially increasing the RAM is used to
ensure the smooth functioning of the computer system. (2)
2.4 A software bug was found while testing software.
2.4.1 What is a software bug? (1)
2.4.2 Give a practical example of how the software bug could be revealed
to the user when running the software. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 6 DBE/November 2022
NSC
2.5 The club management noticed an increase in unauthorised access to their
computers and programs. What can be done to prevent unauthorised access
to software at the centre? (1)
2.6 Mobile technologies have revolutionised the computing world. Some of the
software used at the centre has been designed for use on mobile devices.
2.6.1 Give TWO limitations related to the use of mobile devices when
compared to devices such as PCs and laptops. (2)
2.6.2 Smartphones have the functions and abilities of many different
devices built into a single device. What is the term used for this
design approach? (1)
2.7 The programmers at the club need to develop a system to manage the
recycling centre. They have decided to use a programming language which
uses an interpreter instead of a compiler.
2.7.1 What is the common goal of a compiler and an interpreter? (1)
2.7.2 Motivate why a compiler would be a better choice than an interpreter
for programming in general. (2)
2.8 The implementation of good computer management techniques is essential
for the maintenance of a computer.
2.8.1 Why is it necessary to clean up and arrange the items on a desktop
computer? (1)
2.8.2 Explain why an operating system requires a file extension. (2)
TOTAL SECTION B: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 7 DBE/November 2022
NSC
SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES
QUESTION 3
The Smart Energy Company uses network consultants to advise them regarding their
network.
3.1 The network of the company needs to be upgraded.
3.1.1 Name the most suitable medium with which to connect the following:
(a) Thirty computers at the company's computer centre to form a
local area network (1)
(b) Mobile devices to the company's network (1)
3.1.2 State TWO advantages of installing a wireless network. (2)
3.1.3 State a function that a local network can still perform even when
there is a faulty connection between the internet and the network. (1)
3.2 A consultant suggested that a peer-to-peer network will work better than
a client-server network.
Consider the following diagram:
CLIENT-SERVER PEER-TO-PEER
PC
Server
PC PC
Terminals
PC PC
3.2.1 Give TWO reasons why a peer-to-peer network is less suitable for a
company with many users. (2)
3.2.2 Name a peer-to-peer file transfer protocol used for sharing large files
over the internet (1)
3.2.3 State ONE possible role of a server in a server-based network. (1)
3.2.4 The peer-to-peer network uses a switch (marked X). State ONE
disadvantage when using a switch in a network. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 8 DBE/November 2022
NSC
3.3 According to the consultant, a protocol is a set of rules for encoding and
decoding data for transmission across a network.
3.3.1 (a) State the purpose of the hypertext transfer protocol. (1)
(b) Why has HTTP been extended to the HTTPS protocol? (1)
3.3.2 Explain why data needs to be encoded before being transmitted
over the internet. (2)
3.4 The company requires assistance to market themselves on the internet.
3.4.1 Explain the difference between a website and a web page. (1)
3.4.2 The company decided to use search engine optimisation (SEO) to
promote their website.
(a) What is the purpose of SEO? (1)
(b) State ONE way in which SEO can be applied in the design of
their webpages. (1)
3.5 The consultant advised that a good way to save time when designing and
updating the website is to use CSS language.
Explain how CSS works. (2)
3.6 A person can gain access to the network at his/her workplace using a VPN
service while connecting from a public hotspot.
3.6.1 State TWO security risks that may be encountered when using a
public hotspot. (2)
3.6.2 Explain the process a VPN service follows to give access to a
workplace network. (3)
3.7 The internet has evolved to where Web 3.0 (semantic web) is used
increasingly.
3.7.1 Explain why companies have not abandoned static web pages
completely for their websites. (1)
3.7.2 Dynamic web pages are created by software running on a web
server each time the page is accessed.
State TWO advantages for the users of dynamic web pages when
compared to static web pages. (2)
3.7.3 The semantic web uses metadata to conduct searches.
(a) What is metadata? (1)
(b) Explain how a semantic search would take place. (2)
TOTAL SECTION C: 30
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 9 DBE/November 2022
NSC
SECTION D: DATA AND INFORMATION MANAGEMENT
QUESTION 4
The company named Reduce e-waste collects data from users to make informed
business decisions.
4.1 A loyalty program at stores is a way in which invisible data capturing can take
place.
4.1.1 Give another example of invisible data captured about a customer
during purchases, other than their personal details such as name,
surname and address. (1)
4.1.2 Give ONE reason why a company would want to capture invisible
data on the purchases made by cardholders. (1)
4.1.3 Except for card readers and credit cards, name TWO other
mechanisms of invisible data capturing. (2)
4.2 The company uses a database to store details of their customers.
4.2.1 State TWO ways of ensuring the validity of captured data. (2)
4.2.2 How can two customers with the same name and surname be
distinguished in the database? (1)
4.3 The company attempted to improve the design of their database.
4.3.1 It was found that some of the data was repeated in the database.
(a) What is the term given to the unnecessary repetition of data
across multiple records? (1)
(b) An update anomaly can occur when data is repeated
unnecessarily. Explain how an update anomaly takes place. (2)
4.3.2 A relationship between tables can be created rather than repeating
data in different tables. Identify the type of relationship presented in
EACH of the following diagrams:
(a)
(1)
(b)
Customers
(1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 10 DBE/November 2022
NSC
4.4 The database CollectionDB used by the recycling company consists of two
related tables, tblClients and tblCollections. The details of collections for
recycling are saved in table tblCollections.
4.4.1 Name the type of key formed when multiple fields are used together
as the primary key. (1)
4.4.2 Suggest another key field that can be created in tblCollections
instead of using the three fields as the primary key. (1)
4.4.3 The field ClientID also serves as the foreign key in table
tblCollections.
What will the data type of the primary key field in table tblClients
be? (1)
4.4.4 Referential integrity is enforced between the two tables
tblCollections and tblClients. Explain the term referential integrity. (1)
4.4.5 The accounts department uses parallel data sets to store the data
they work with.
Indicate whether the following statements related to parallel data
sets are TRUE or FALSE. Write only 'true' or 'false' next to the
question numbers (4.4.5(a) to 4.4.5(d)) in the ANSWER BOOK.
(a) Multiple copies of the data are kept. (1)
(b) Downtime is expected when a data set gets damaged. (1)
(c) Parallel data sets use less storage than distributed databases. (1)
(d) Parallel data sets are used when mining data. (1)
TOTAL SECTION D: 20
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 11 DBE/November 2022
NSC
SECTION E: SOLUTION DEVELOPMENT
QUESTION 5
5.1 Procedures and functions are coding constructs often used as part of modular
programming.
5.1.1 Give a reason for the use of modular programming. (1)
5.1.2 State ONE difference between a procedure and a function. (1)
5.2 State whether each of the following statements are valid or invalid:
5.2.1 X := Y = 2;
where the data type of X is Boolean and Y is integer (1)
5.2.2 If Name1 > Name2 then
…..
where Name1 and Name2 are declared as string type variables. (1)
5.3 Many programmers use defensive programming techniques in their code.
5.3.1 Explain what defensive programming is. (2)
5.3.2 While the program was running, an error caused the program to stop
executing. The following error message was displayed:
'Execution halted – an overflow error occurred'
(a) Give a possible reason for an overflow error. (1)
(b) State a way in which programming code can be used to prevent
a runtime error. (1)
5.4 The following class was designed using object-oriented programming (OOP)
principles. Study the class diagram below and answer the questions that
follow.
RecycleCompany
Attributes
- CompanyNum
- CompanyName
- Address
+ ContactNumber
+ NumberOfEmployees
+ Constructor(CompanyNum, CompanyName,
Methods
Address, ContactNumber)
+ getCompanyName():String
+ isValidContactNumber():Boolean
+ toString():String
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 12 DBE/November 2022
NSC
5.4.1 State the purpose of a constructor method. (1)
5.4.2 Identify an accessor method from the class diagram. (1)
5.4.3 Mutator methods will be required for the object.
(a) For which attribute will the use of a mutator method be the
LEAST applicable? (1)
(b) Motivate your answer to QUESTION 5.4.3(a). (1)
5.4.4 OOP classes use both private and public access specifiers.
(a) State where in the class diagram access specified to
methods/attributes violates the recommended/allowed access
to methods/attributes. (1)
(b) Explain why the incorrect access to methods/attributes
identified in QUESTION 5.4.4(a) might cause a problem when
working with an object of this class. (2)
5.5 A company randomly selects one of 10 bins for paper recycling, excluding
bins that are already full. Presently bins 5 and 8 are already full.
A random number must be generated repeatedly until a bin number other
than 5 or 8 is identified to be used for the next load of recycling paper.
5.5.1 When would a sentinel controlled/conditional loop be preferred to
other loops? (1)
5.5.2 The following code was used to generate a random number in the
range 1 to 10, excluding numbers 5 and 8.
Repeat
iNumber := RandomRange(1,11);
Until (iNumber <> 5) AND (iNumber <> 8);
Rewrite the code using a WHILE loop. (4)
TOTAL SECTION E: 20
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 13 DBE/November 2022
NSC
SECTION F: INTEGRATED SCENARIO
QUESTION 6
A company named e-Waste Technologies Africa specialises in the recycling of
electronic waste.
6.1 Recycling in the 21st century plays a critical role to save our planet. Many
companies and households need to manage their electronic waste.
6.1.1 Define the term electronic waste. (1)
6.1.2 Give ONE reason why electronic waste is often hazardous to the
environment. (1)
6.1.3 State TWO ways to reduce electronic waste. (2)
6.1.4 Explain what should be done with regard to a user's privacy with any
electronic storage device before it is recycled/discarded. (1)
6.2 Large recycling companies require internet connection for all the staff working
at the different branches and depots.
6.2.1 The employees at a branch must be able to communicate effectively
with employees at other branches.
(a) The employees use e-mail for daily communication.
Differentiate between the POP protocol and the IMAP protocol
used for e-mail. (2)
(b) Spam is a problem for the employees at the company.
State ONE way in which spam affects the company negatively. (1)
(c) Fake news usually spreads rapidly over the internet and has
the potential to cause chaos.
Suggest TWO possible ways how to identify fake news. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 14 DBE/November 2022
NSC
6.2.2 An employee attempted to send an e-mail with an attachment, but
the following error message appeared:
(a) State another way in which to send the attachment
successfully over the internet. (1)
(b) State ONE risk of sending the attachment when using your
suggested method in QUESTION 6.2.2(a). (1)
(c) Explain what a media repository is. (1)
(d) Define the term ubiquity in terms of the way in which we work
with files on the internet. (1)
6.3 It is important for staff working in the finance department to remain up to date
with current threats and scams.
6.3.1 A RAT (remote access Trojan) was detected on one of the
computers connected to the company's network.
(a) Briefly explain what a RAT is. (1)
(b) State TWO ways in which a user's computer could be infected
with Trojan malware. (2)
6.3.2 Give TWO reasons why websites are often hacked. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 15 DBE/November 2022
NSC
6.4 The company uses a distributed database as their clients are spread over a
large geographical area.
6.4.1 Explain what a distributed database is. (2)
6.4.2 What is the main difference between the Duplication model and
Partitioning model in terms of the data that they store? (2)
6.4.3 Discuss why there is a need for regular data synchronisation when a
distributed database model is used. (2)
6.5 The recycling company is also actively involved in finding solutions to the
challenges posed by pollution.
6.5.1 The company uses a system that gathers information from a variety
of sources, analyses it and presents it in a structured format to
support decision-making.
What is such a system called? (1)
6.5.2 Explain how an expert system/knowledge-based system can be
used in conjunction with the system in QUESTION 6.5.1 to ensure
quick automated decision-making. (2)
6.6 The employees at the company were provided with notebook computers with
an open-source operating system to work from home.
6.6.1 What does open-source refer to? (1)
6.6.2 The notebook computers quickly ran out of storage space due to the
amount of data employees store on the hard drives. It was
suggested that the disk clean-up utility be used to free up storage
space.
Name ONE type of file that the disk clean-up program will identify
and remove during scanning. (1)
6.6.3 The digital divide results in some employees not being able to work
from home.
(a) Define the term digital divide. (1)
(b) State TWO factors that contribute to the digital divide. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 16 DBE/November 2022
NSC
6.7 Hyper-automation and robotics process automation (RPA) are some of the
new emerging technologies that has the potential to maximise the efficiency
of company operations around the world.
6.7.1 Explain the difference between hyper-automation and RPA. (2)
6.7.2 An analysis of the demographics of most developed countries show
an aging population.
Discuss how RPA will help solve this problem in order to keep
factories running. (2)
6.8 Extended reality is a broad term that includes virtual reality, augmented reality
and mixed reality.
6.8.1 Differentiate between virtual reality and augmented reality. (2)
6.8.2 How is mixed reality a further improvement on the realities named in
QUESTION 6.8.1? (1)
TOTAL SECTION F: 40
GRAND TOTAL: 150
Copyright reserved
Study this subject
Recommended for this subject

Question paper
Information Technology Grade 12 P1 NSC November 2022 QP

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

Question paper
Information Technology Grade 12 P2 Eastern Cape Mock 2022 QP
_hlayiso.com_--7454979b-cba2-4b39-a884-69e6b1c0f5c6/v1-3f9dc1675d92ae7768e5/card.webp)
Question paper
Information Technology Grade 12 P2 NSC June 2022 QP (Eng)
_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 NSC November 2019 QP
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