Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2016
INFORMATION TECHNOLOGY P2
MARKS: 150
TIME: 3 hours
*INFTE*
This question paper consists of 14 pages.
Skip to contentAll 2016 papers 

_hlayiso.com_--6f6966c3-a4a0-4de2-8abc-b82595b1e6b7/v1-fe9ade12805234cad6b4/card.webp)



View all





Information Technology Grade 12 P2 Eastern Cape Mock 2016 QP
Grade 12 Information Technology Paper 2 question paper from the Eastern Cape Mock Exam 2016, 15 pages. Read online or download the free PDF.
Information Technology · Grade 12 · Eastern Cape Mock Exam · 2016. Question paper, 15 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2016
- Exam period
- Eastern Cape Mock Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 15
- File size
- 418.9 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 15
This exam
Eastern Cape Mock Exam 2016
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
INSTRUCTIONS AND INFORMATION
1. This question paper consists of SIX questions:
SECTION A: Short questions (15)
SECTION B: System Technologies (24)
SECTION C: Communications and Network Technologies (26)
SECTION D: Data and Information Management (26)
SECTION E: Solution Development (22)
SECTION F: Integrated Scenario (37)
2. Answer ALL the questions.
3. Read ALL the questions carefully.
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
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 3
SECTION A: SHORT QUESTIONS
QUESTION 1
1.1 Give ONE word/term for each of the following descriptions. Write only the
word/term next to the question number (1.1.1–1.1.10) in the ANSWER
BOOK.
1.1.1 A field that identifies each record with a unique value (1)
1.1.2 Performance of physical tasks, commonly repetitive or dangerous
ones, by computer-controlled machines rather than by human
beings (1)
1.1.3 A set of rules for encoding and decoding data for transmission
across a network (1)
1.1.4 A device that makes it possible for networks to communicate over
the Internet, by directing data to its correct destination (1)
1.1.5 A form of malware that tries to monitor and track the way you use
your computer to discover confidential information, and then relay
this to a third party (1)
1.1.6 Trend whereby separate technologies and functions from multiple
devices are combined into a single multi-purpose device (1)
1.1.7 The ‘scrambling’ of text or data using a specified set of rules to
ensures the privacy of data during communication, or for security
purposes (1)
1.1.8 When the DBMS gets the instructions to reverse a transaction (or
series of transactions) and restores the data back to its previous
state (1)
1.1.9 A huge collection of data, often accumulated from a range of
sources such as separate databases within a company (1)
1.1.10 A type of reasoning that works with probabilities in order to arrive at
a decision (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
4 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
1.2 Various options are given as possible answers to the following questions.
Choose the answer and write only the letter (A–D) next to the question
number (1.2.1–1.2.5) in the ANSWER BOOK.
1.2.1 Copyrighted software provide to a user at no cost is known as …
A shareware.
B wrap ware.
C freeware.
D adware. (1)
1.2.2 Which technique allows the processor of a computer system to run at
a speed faster than the motherboard normally supports?
A Pipelining
B Cache
C Hyperthreading
D Clock multiplication (1)
1.2.3 Which one of the following software items is used for developing web
pages?
A SQL
B HTTP
C HTML
D CSS (1)
1.2.4 The concept of hiding the details of an object is known as …
A abstraction.
B data mining.
C modular programming.
D encapsulation. (1)
1.2.5 A/An … directly executes, i.e. performs, instructions written in a
programming or scripting language, without previously compiling them
into a machine language program.
A interpreter
B computer
C compiler
D programmer (1)
TOTAL SECTION A: 15
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 5
SECTION B: SYSTEMS TECHNOLOGIES
QUESTION 2
One of your cousins is a manager at a local plant nursery, one of their computers has
stopped working and after sending it for repairs he is told that the motherboard is faulty
and needs to be replaced. Here are some of the specifications of the replacement
motherboard.
CPU VGA
Intel Socket 775 Core™2 Duo/Pentium® Intel Graphics Media Accelerator 950
D/Pentium® 4/Celeron D Processors Max. resolution:2048x1536@75Hz
Compatible with Intel® 05B/05A/06 processors Max. Vertical Refresh Rate:85Hz@ up to 1920x1440
Intel® Hyper-Threading Technology ready
* Refer to www.asus.com for Intel CPU support list
Memory
2 x DIMM, Max. 4 GB, DDR2 667/533 Non-ECC,Un-buffered Memory
Dual Channel memory architecture
* Refer to www.asus.com or user manual for Memory QVL (Qualify Vendor List)
**When installing total memory of 4GB capacity or more, Windows® 32-bit operation system may only
recognise less than 3GB. Hence, a total installed memory of less than 3GB is recommended.
Chipset Front Side Bus Expansion Slots
Intel 945GC 1333/1066/800/533 MHz 1 x PCIe x16 @16
ICH7 1 x PCIe x1
2 x PCI
[Source: https://www.asus.com/za/Motherboards/P5GCMX1333/specifications/]
2.1 Explain the purpose of the motherboard, by giving THREE core functions. (3)
2.2 Refer to the System Clock and identify the highest system clock speed in the
example. Answer the following questions.
2.2.1 What is the highest speed of the System Clock? (1)
2.2.2 State the relationship between System Clock and Front Side Bus. (1)
2.2.3 Which components are connected through the Front Side Bus? (2)
2.3 The CPU speed is given as being a 3.46 GHz processor, 512 MB L2 Cache and
2 MB L3 Cache.
2.3.1 Explain how the processor is able to work with the motherboard, since
the motherboard speed is less than that of the processor. (2)
2.3.2 Briefly explain the purpose of cache in the processor. (1)
2.3.3 List AND explain TWO other places in the computer system where the
cache is employed. (4)
Copyright reserved Please turn over
Downloaded from hlayiso.com
6 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
2.4 You discuss with friends and one suggests that you use a tablet, and that it
will do the same job, whilst the other one states that a tablets is not modular
designed so it will not do the same job.
2.4.1 Are tablets modular designed? Justify your answer. (2)
2.4.2 Explain TWO advantages of modular design. (2)
2.5 One of your friends indicates that the operating system is very important for
the computer system to work, and the best systems are open source.
2.5.1 State TWO functions of operating system software. (2)
2.5.2 List TWO advantage of open source software. (2)
2.5.3 List TWO disadvantage of open source software. (2)
TOTAL SECTION B: 24
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 7
SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES
QUESTION 3
Computers, laptops, tablets and phones need to connect in order to share data,
pictures, documents and databases amongst the three plant nursery branches, one
in East London, another in Port Elizabeth and this one in Mthatha.
3.1 Advise on AND define the type of network that must be set up:
3.1.1 Between the branches (1)
3.1.2 At each branch (1)
3.2 Apart from cables, you want to know what hardware will be required to set up
the network at each branch. Motivate why EACH of the following items are
required by briefly explaining the function of each item in a network:
3.2.1 Network interface cards (NIC) (3)
3.2.2 Switch (2)
3.3 In order to communicate amongst each other one of the managers suggests
that they must use twitter or Skype.
3.3.1 Which one of the two uses VOIP? (1)
3.3.2 Expand and explain the acronym VOIP. (2)
3.3.3 Which one of the two mediums of communication mentioned, refers
to a microblog? (1)
3.3.4 Define a microblog by comparing it to a blog. (2)
3.4 While researching on a certain flower plan, you visit a website and you see
the following message:
‘This site uses cookies, by clicking and continuing browsing, it means you are
in agreement …’
3.4.1 Explain what cookies are. (2)
3.4.2 State the main advantage of using cookies as the user. (1)
3.4.3 How can you ensure/verify that that the information found on the site
is reliable? (2)
3.4.4 You also discover that the site uses digital certificates. What is the
purpose of a digital certificate? (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
8 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
3.5 Sharing files online using a popular cloud storage facility has been
recommended for your team by the network administrator.
3.5.1 Provide at least TWO file sharing facilities/websites available online. (1)
3.5.2 The shared folders with information usually have different
permissions, depending on the user. State AND explain TWO types
of permissions that can be granted to a user of a shared folder. (4)
3.5.3 Are documents saved in these shared folders safe from viruses?
Explain why. (2)
TOTAL SECTION C: 26
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 9
SECTION D: DATA AND INFORMATION MANAGEMENT
QUESTION 4
A database has been designed with information about the plants available in the
nurseries.
4.1 The database needs to be accessible by the POS systems and other
applications including the website, from all three centres but will be
administered from one location.
4.1.1 Identify the appropriate type of database management system to
use. (1)
4.1.2 Give an appropriate example of the database management
system mentioned in QUESTION 4.1.1. (1)
4.1.3 Give TWO advantages of this type of database management
system. (2)
4.1.4 Would you recommend this type of database management system
for a worldwide corporation whose information changes every
minute, from location to location? Substantiate your answer. (2)
4.2 Whilst discussing with the database administrator it is mentioned that the
database must be data independent and data security needs to be
implemented.
4.2.1 Give TWO functions of a database administrator. (2)
4.2.2 What does data independence mean? (1)
4.2.3 Give TWO advantages of data independence. (2)
4.2.4 Explain what is meant by data security. (1)
4.2.5 Suggest TWO ways of securing the data. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
10 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
4.3 Whilst designing the database, the following tables are proposed:
4.3.1 What does the term foreign key refers to? (1)
4.3.2 Identify the foreign key field in the Plant Details table. (1)
4.3.3 An attempt to normalise the database has been made. Explain what is
meant by the term normalisation. (2)
4.3.4 Name THREE common types of anomalies associated with a poorly
designed database. (3)
4.4 In order to create queries SQL is being used.
4.4.1 Write a statement to show all the information from the Plant Details
table. (2)
4.4.2 Write a statement that will update the botanical name called ‘Merwilla
pumbea’ to ‘Merwilla plumbea’. (3)
TOTAL SECTION D: 26
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 11
SECTION E: SOLUTION DEVELOPMENT
QUESTION 5
Programs to be used in the administrative office are being developed.
5.1 The following class diagram has been designed for the plant management
program.
Plant
Attributes Methods
-fplantID:String +getName:String;
-fplantName:String; +getBotanicalName:String;
-fBotanicalName:String; -getStock:Real;
-fPrice:Real +Constructor Create(cplantID, cplantName,
-finStock:Boolean; cBotanicalName:String,cPrice:Real)
+toString:String;
5.1.1 Explain what the (-) and the (+) signs mean. (2)
5.1.2 Identify an accessor method in the Plant class. (1)
5.1.3 What is the purpose of the constructor method? (1)
5.1.4 Would it be possible to use the class Plant without the constructor
method? Explain your answer. (2)
5.2 Analyse the following flowchart.
iNumber:=13
No
iNumber<100
Yes
Display iNumber
iNumber:=iNumber +13
Statement
Copyright reserved Please turn over
Downloaded from hlayiso.com
12 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
5.2.1 Identify the type of loop indicated in the flowchart diagram above. (1)
5.2.2 Identify the statement(s) that are repeated. (2)
5.2.3 How many repetitions will take place? (1)
5.2.4 What is the condition for the loop to stop? (1)
5.2.5 Write the Pseudo code described by the flowchart. Display
appropriate statements where needed. (6)
5.3 Arrays will be used to store and manipulate some of the data.
5.3.1 Define an array. (2)
5.3.2 Write an example of a one-dimensional constant array
declaration. (3)
TOTAL SECTION E: 22
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2016) INFORMATION TECHNOLOGY P2 13
SECTION F: INTEGRATED SCENARIO
QUESTION 6
A website showcasing the company’s services and plants has been designed.
Short videos, pictures and descriptions of plants including important information
about the workers are all available on the site.
6.1 The website is hosted on website hosting company’s servers.
6.1.1 Name the type of software program that can be used to access the
website. Give ONE example. (2)
6.1.2 Which protocol (give full name) will be used to transmit the website
data when another computer on the internet requests information
from the hosting company’s server? (1)
6.1.3 The monthly bandwidth allowed by the hosting company is 10 GB.
Explain what is meant by the term bandwidth. (2)
6.1.4 Will it be possible for the company to host the website on their own
to avoid paying the website hosting company? Substantiate your
answer. (3)
6.2 The company has hired security consultants to advise them on many
security aspects to help protect them from computer criminals and theft.
The company plans to use e-mail, Twitter and Facebook extensively for
their marketing activities online.
6.2.1 Name THREE items of personal information that should not be
posted on a social networking site. (3)
6.2.2 Explain how hackers may use your e-mail to steal your personal
information. (2)
6.2.3 Give ONE name used to describe this occurrence in QUESTION
6.2.2. (1)
6.2.4 One of the managers explains that he was trolled online. What is
trolling? (1)
6.2.5 What measures can the manager take to avoid trolling? (1)
6.2.6 List THREE types of computer theft. (3)
6.2.7 List THREE types of computer criminals. (3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
14 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2016)
6.3 An app has been designed by one of the programmers you hired which will
enable buyers to select the plants that they may need to put in their
gardens. One of the managers claims that appification has taken over the
Internet.
6.3.1 What is an app? (1)
6.3.2 Suggest TWO devices that can be loaded with this app. (2)
6.3.3 What does the term appification mean? (2)
6.4 Each nursery has a Wi-Fi network to enable the managers and workers to
share work.
6.4.1 What is Wi-Fi? (1)
6.4.2 One of the managers comes to you and complains that sometimes
he is connected to the Wi-Fi but does not have Internet access.
Explain how this is possible. (2)
6.4.3 Which term is used to refer to the practice of intercepting data
packets on a network? (1)
6.4.4 For EACH of the following technologies, state whether it is possible
to protect the nursery’s data from being intercepted and used. Give
a reason for your answer in EACH case.
(a) Firewall (2)
(b) Encryption (2)
(c) Virus Scan (2)
TOTAL SECTION F: 37
GRAND TOTAL: 150
Copyright reserved Please turn over
Downloaded from hlayiso.com
Study this subject
Recommended for this subject

Memorandum
Information Technology Grade 12 P2 2016 Memo

Memorandum
Information Technology Grade 12 P2 2016 Memo (Afr)
_hlayiso.com_--6f6966c3-a4a0-4de2-8abc-b82595b1e6b7/v1-fe9ade12805234cad6b4/card.webp)
Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2016 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

Question paper
Information Technology Grade 12 P2 Eastern Cape Mock 2020 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