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





View all





Information Technology Grade 12 P2 NSC November 2018 QP
Grade 12 Information Technology Paper 2 question paper from the NSC November Exam 2018 (English), 16 pages. Read online or download the free PDF.
Information Technology · Grade 12 · NSC November Exam · 2018. Question paper, 16 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2018
- Exam period
- NSC November Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 16
- File size
- 588.8 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 16
This exam
NSC November Exam 2018
Questions in this paper
- Question 1.1Solution Development and Software Engineering7 marks
- Question 1.2Systems Technologies8 marks
- Question 2Systems Technologies23 marks
- Question 3Systems Technologies42 marks
- Question 4Database Design and SQL24 marks
- Question 5Solution Development and Software Engineering30 marks
Show all 7 questions
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P2 2 DBE/November 2018
NSC
INSTRUCTIONS AND INFORMATION
1. This question paper consists of SIX sections:
SECTION A: Short Questions (15)
SECTION B: System Technologies (23)
SECTION C: Communication and Network Technologies (21)
SECTION D: Data and Information Management (25)
SECTION E: Solution Development (29)
SECTION F: Integrated Scenario (37)
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 2018
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 type of malware that is disguised as a useful program is known
as a …
A virus.
B rootkit.
C worm.
D trojan horse. (1)
1.1.2 Software that may be used for free but with a time and functionality
limit:
A EULA
B Shareware
C Proprietary software
D Freeware (1)
1.1.3 Which ONE is NOT a duty of a system analyst?
A Analyses the software requirements of the client
B Collaborates with the client and the programmer to develop
a system
C Creates a list of specifications for the software developer
D Writes code for the software solution (1)
1.1.4 What will be the value of iAnswer when the following statement is
executed?
iAnswer := 2 + 5 * 7 div 2 – sqr(4);
A 3
B 8
C 1
D 0 (2)
1.1.5 Which formula is represented in the segment of code below?
for k := 2 to p do
begin
n:= n * n;
end;
A n*p
B np
C pn
D pp (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 4 DBE/November 2018
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.8) in the
ANSWER BOOK.
1.2.1 Part of the ROM where information with regard to the setup of the
computer can be saved (1)
1.2.2 Security based on the measurement and identification of unique
physical characteristics of a person, e.g. fingerprints (1)
1.2.3 Digital code, attached to an e-mail, used to identify and validate the
sender of an electronic message (1)
1.2.4 Software that allows the user to perform maintenance tasks on
a computer (1)
1.2.5 The method that is used in object-oriented programming to
instantiate an object (1)
1.2.6 The steps followed to prevent anomalies from occurring in
a database (1)
1.2.7 A tool used to identify logical errors by working through the
program manually step by step and recording the result of each
step in a table (1)
1.2.8 Compressing data by losing some insignificant portions of the data (1)
TOTAL SECTION A: 15
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 5 DBE/November 2018
NSC
SECTION B: SYSTEM TECHNOLOGIES
QUESTION 2
A chain of fast-food restaurants is opening a new branch in the local shopping mall.
The IT infrastructure of the mall is modern.
2.1 Tablet computers will be used to place orders directly on the system in the
new restaurant.
Give TWO reasons why the use of tablet computers is appropriate for this
purpose. (2)
2.2 The mall server will store all the records.
2.2.1 Name TWO hardware components for which the specifications will
be of a higher level in the server, as opposed to those for a
standard PC. (2)
2.2.2 State TWO types of actions that will be performed by a disk
clean-up when clearing space on the server's hard disk drive. (2)
2.3 Many restaurants owners are considering an upgrade of their computer
systems.
2.3.1 State TWO important differences between standard RAM and
cache memory in a computer system. (2)
2.3.2 What is the function of the device driver that is installed when
adding a new printer? (2)
2.3.3 What is the purpose of the product key or activation code that is
often required when installing new software? (1)
2.3.4 The operating system indicated that updates were available.
(a) State ONE advantage of ensuring that the operating system
is updated regularly. (1)
(b) State ONE disadvantage of allowing the operating system to
update automatically. (1)
2.3.5 Virtual memory can enhance the performance of the computer.
(a) When will virtual memory be used by the operating system? (1)
(b) Explain the basic concepts of how virtual memory works. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 6 DBE/November 2018
NSC
2.4 Safeguarding of the data is vital.
2.4.1 Give ONE reason why a hard disk drive could fail. (1)
2.4.2 Suggest ONE device that could protect data from being corrupted
during a power failure. (1)
2.4.3 Explain the difference between making a backup and archiving
data. (3)
2.4.4 Explain the role of a firewall as a means of data protection. (2)
TOTAL SECTION B: 23
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 7 DBE/November 2018
NSC
SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES
QUESTION 3
3.1 Sharing resources is an important benefit of using networks.
State TWO other benefits of having a computer network in a company. (2)
3.2 In laptop computers NICs are used to provide both Wi-Fi connection and an
Ethernet port.
3.2.1 Explain the function of an NIC when providing network connectivity. (2)
3.2.2 What medium is used to send and receive data in a Wi-Fi network? (1)
3.3 Communication performance in cabled and wireless networks is often
compared.
3.3.1 Name a type of network cable that has a very low level of
attenuation of signal. (1)
3.3.2 Explain how poor signal strength can be addressed when setting
up wireless communication networks. (2)
3.3.3 Give TWO reasons why companies providing wireless internet
access prefer to use WiMAX instead of Wi-Fi. (2)
3.4 Web 3.0 is often referred to as the 'Semantic Web'.
3.4.1 Explain what is meant by the term Semantic Web. (2)
3.4.2 What is the purpose of metadata in the Semantic Web? (1)
3.5 E-mail remains a popular means of communication.
3.5.1 Which protocol is used to download e-mail? (1)
3.5.2 Differentiate between notifications and push technology in terms of
the way e-mail is handled on a mobile device. (2)
3.5.3 Explain how a cloud-based service can be used to make large files
available to an e-mail recipient, without attaching the files to the
e-mail. (2)
3.5.4 Phishing is a technique often used by cyber criminals.
(a) Explain the term phishing. (2)
(b) Give ONE example of phishing. (1)
TOTAL SECTION C: 21
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 8 DBE/November 2018
NSC
SECTION D: DATA AND INFORMATION MANAGEMENT
QUESTION 4
Some restaurants use a database and an efficient database management system for
their administration, orders and point of sale (POS).
4.1 Name ONE possible role of a database in the POS system of a restaurant. (1)
4.2 The job card below contains information about a waiter in a restaurant for a
specific week.
Job Card No.:
Weekly Job Card for Waiters JC10012
Initial and Surname K Nel Waiter ID W001
Permanent
Appointment
Start of Week: 1 October 2018
Hours worked:
Normal hours worked: 27.5 hours
Overtime hours worked: 6 hours
Total hours worked: 33.5 hours
4.2.1 A database with the following tblWaiter table has been designed:
tblWaiter
Field Name Data Type
PK WaiterID 4.2.1(a)
Initial and Surname Text
Permanent Appointment 4.2.1(b)
Use the information provided on the job card to suggest a suitable
data type for EACH of the following fields:
(a) WaiterID (1)
(b) Permanent Appointment (1)
4.2.2 A report with an alphabetical list of waiters, sorted according to
their surnames, is required.
Evaluate the structure of the tblWaiter table and state the problem
that will arise when attempting to generate the report. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 9 DBE/November 2018
NSC
4.2.3 A second table, tblJobCard, needs to be created to save the
remaining information on the job card.
The table below represents a tblJobCard table for the waiters.
Redraw this table in your ANSWER BOOK.
tblJobCard
Field Name
PK
NormalHoursWorked
: :
: :
Use the information on the weekly job card (on the previous page)
and complete the tblJobCard table in your ANSWER BOOK as
follows:
(a) Identify and add the field name of a suitable primary key
(PK).
(b) List other field names that must appear in the tblJobCard
table in addition to the NormalHoursWorked field.
(c) Identify and add an applicable foreign key (FK). Use the
abbreviation FK in the first column.
NOTE:
• Each job card record must relate to a waiter.
• Follow the rules for normalisation. (6)
4.2.4 Draw a simple entity-relationship diagram (ERD) to show the
relationship between the tblWaiter table and tblJobCard table. (3)
4.3 The physical integrity of data is just as important as the logical integrity.
4.3.1 Identify ONE issue that could threaten the physical integrity of data
in general. (1)
4.3.2 State TWO database design aspects that will ensure logical
integrity. (2)
4.4 An advertisement for a database administrator for a restaurant must be
placed in the local newspaper.
State THREE primary responsibilities of a database administrator. (3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 10 DBE/November 2018
NSC
4.5 State TWO benefits of having a DBMS installed on a server. (2)
4.6 A restaurant group uses a distributed database system.
4.6.1 Suggest ONE reason why a distributed database system would
require sophisticated security when compared to a database
system stored on a single computer. (1)
4.6.2 What is the benefit of working on a distributed database rather than
on a single-server database, from a user's perspective? (1)
4.6.3 Briefly explain how data synchronisation is done when using a
partitioning model in a distributed database. (2)
TOTAL SECTION D: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 11 DBE/November 2018
NSC
SECTION E: SOLUTION DEVELOPMENT
QUESTION 5
The manager of a restaurant approached a novice programmer to improve an
outdated program used for reservations.
5.1 Answer the questions below on general aspects and concepts related to
programming.
5.1.1 State TWO guidelines for writing clear and readable source code. (2)
5.1.2 Define the concept of an algorithm in programming. (2)
5.1.3 Debugging is an integral part of programming.
(a) Explain what is meant by debugging a program. (2)
(b) (i) What is a runtime error? (1)
(ii) Give an example of a type of error that will lead to
a runtime error. (1)
5.1.4 Looping is a common programming structure.
Compare the structure and execution of a WHILE…DO loop and
a REPEAT…UNTIL loop. (2)
5.1.5 Identify the data types for variables X and Y when executing the
following two instructions:
X := 5 mod 2;
AND
Y := 5 mod 2 = 0; (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 12 DBE/November 2018
NSC
5.2 Bookings are saved in a text file called Bookings.txt.
procedure TForm1.btnReadFromFileClick(Sender: TObject);
Var
tFile: TextFile;
sLine: String;
begin
AssignFile(tFile, 'Bookings.txt');
Reset(tFile);
while not eof(tFile) do
readln(tFile, sLine);
end;
procedure TForm1.btnAddToFileClick(Sender: TObject);
Var
tFile: TextFile;
sLine: String;
begin
AssignFile(tFile, 'Bookings.txt');
Append(tFile);
writeln(tFile, 'Mrs A Smith#19:30');
CloseFile(tFile);
end;
5.2.1 Explain the purpose of the following line of code:
AssignFile(tFile,'Bookings.txt'); (2)
5.2.2 State the effect of replacing Append(tFile) with
Rewrite(tFile) in the procedure above. (2)
5.2.3 The user needs to save data to a text file.
When a button was clicked to write the data to the text file, an
Input/Output file error occurred.
Give a possible reason why the I/O error occurred. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 13 DBE/November 2018
NSC
5.3 The algorithm below is used to test the validity of a pin code.
Line Algorithm_Validate_Pin
1 Input PIN
2 c0
3 x PIN
4 Repeat
5 x x / 10
6 cc+1
7 Until x < 1
8 If c <> 5 then
9 Display 'Error in PIN'
10 Else
11 Display 'PIN Accepted'
5.3.1 Copy the trace table below into your ANSWER BOOK and
complete it to determine the output value if 623 is entered as the
pin value.
Pin x c Is x < 1? Is c <> 5? Display
623 623 0
(6)
5.3.2 Analyse the completed trace table and state what the requirement
is for the pin to be valid. (1)
5.4 An algorithm is required to display a pattern, based on the number that was
entered indicating the number of lines to be displayed.
Example: If the value 6 is entered, the pattern below must be displayed:
Complete the algorithm from line 3 below to display the pattern based on any
input value.
Line Algorithm_Display_Pattern
1 Input number
2 Loop counter 1 to number
3 …
(5)
TOTAL SECTION E: 29
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 14 DBE/November 2018
NSC
SECTION F: INTEGRATED SCENARIO
QUESTION 6
The days when restaurants could rely exclusively on good food, an enjoyable
ambience and word-of-mouth advertising are quickly coming to an end. More and more
restaurants realise that they must use consumer-facing connected technologies, such
as websites, social networks and mobile apps, to stay competitive. The manager at a
local restaurant decided to implement these technologies.
6.1 The restaurant created an unsecured hotspot for their guests.
6.1.1 What is a hotspot? (2)
6.1.2 Name the threat for a guest when using an unsecure hotspot. (1)
6.1.3 The use of BitTorrent has been blocked on the network by the
firewall.
(a) What is BitTorrent? (1)
(b) Give TWO reasons why the restaurant owner insists that
BitTorrent be blocked. (2)
6.2 The hotspot in the restaurant is used by business people to connect to their
company's VPN.
6.2.1 Write out the abbreviation VPN. (1)
6.2.2 Briefly explain what a VPN is. (2)
6.3 The restaurant upgraded their website.
6.3.1 The URL for a page on the website for this restaurant is given
below.
http://www.mydinnersite.com/product.asp?id=12345
(a) Is this a static or dynamic web page? Motivate your answer. (2)
(b) How would the URL change to indicate that it is a mobile
site? (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 15 DBE/November 2018
NSC
6.3.2 A paragraph on the home page of the website encourages users to
use less power.
(a) Give TWO hints for saving power when using computing
devices. (2)
(b) Suggest ONE environmentally friendly way in which the
restaurant could dispose of its old electronic equipment. (1)
6.3.3 Name the technique that is used to ensure that the restaurant's
website is placed as high as possible on a list of search results. (1)
6.4 Cybercrimes, such as DDoS, are common phenomena in cyberspace today.
6.4.1 Briefly explain what a DDoS attack on the restaurant's website
might entail.
NOTE: NO marks will be allocated for writing out the acronym. (2)
6.4.2 Suggest TWO measures that the restaurant could implement to
prevent cybercrime. (2)
6.5 The restaurant encourages their guests to download the Foursquare app to
their mobile devices.
6.5.1 Explain what a connected app is. (2)
6.5.2 Give TWO reasons why an app is more popular than conventional
web pages when using certain websites. (2)
6.5.3 (a) What type of technology makes location-based services,
such as Foursquare, possible? (1)
(b) State TWO benefits of a check-in service, such as
Foursquare, from a restaurant's perspective. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P2 16 DBE/November 2018
NSC
6.6 The process of data mining of data in a data warehouse produced the graph
below of the monthly income of the restaurant.
Dine-is-Fine Restaurant – Monthly Income
Income
Months
6.6.1 Explain the purpose of a data warehouse. (2)
6.6.2 State TWO roles that people play in the data-mining process. (2)
6.6.3 What is the purpose of data mining in this context? (2)
6.7 An application program for a specific task is required. Both a desktop package
and an online application have the functions needed. Both packages involve
additional cost.
6.7.1 State TWO advantages of using the online application. (2)
6.7.2 Give ONE reason why the desktop package could be regarded as
the preferred choice. (1)
TOTAL SECTION F: 37
GRAND TOTAL: 150
Copyright reserved
Study this subject
Recommended for this subject

Question paper
Information Technology Grade 12 P2 NSC November 2018 QP

Memorandum
Information Technology Grade 12 P2 NSC November 2018 Memo

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

Question paper
Information Technology Grade 12 P2 NSC November 2022 QP

Question paper
Information Technology Grade 12 P2 NSC November 2019 QP

Question paper
Information Technology Grade 12 P2 NSC November 2017 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