Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
SEPTEMBER 2015
INFORMATION TECHNOLOGY P2
MARKS: 150
TIME: 3 hours
*INFTDM2*
This question paper consists of 14 pages.
Skip to contentAll 2015 papers _hlayiso.com_--ede4321e-b5a0-403e-a86f-4199fa522997/v1-855a626a687615377d16/card.webp)


_hlayiso.com_--053b6720-3be0-4739-8737-7f0b610b5f60/v1-3d19c9dfc8e924c4cf55/card.webp)


View all





Information Technology Grade 12 P2 Eastern Cape Mock 2015 QP
Grade 12 Information Technology Paper 2 question paper from the Eastern Cape Mock Exam 2015 (English), 14 pages. Read online or download the free PDF.
Information Technology · Grade 12 · Eastern Cape Mock Exam · 2015. Question paper, 14 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2015
- Exam period
- Eastern Cape Mock Exam
- Paper
- 2
- Curriculum
- CAPS
- Pages
- 14
- File size
- 455.5 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 14
This exam
Eastern Cape Mock Exam 2015
Questions in this paper
- Question 1.1Social Implications1 marks
- Question 1.2Systems Technologies1 marks
- Question 1.3Systems Technologies1 marks
- Question 1.4Solution Development and Software Engineering1 marks
- Question 1.5Systems Technologies1 marks
- Question 1.6Systems Technologies1 marks
Show all 15 questions
- Question 1.7Systems Technologies1 marks
- Question 1.8Object-Oriented Programming1 marks
- Question 1.9Solution Development and Software Engineering1 marks
- Question 1.10Systems Technologies1 marks
- Question 2Systems Technologies20 marks
- Question 3Systems Technologies28 marks
- Question 4Database Design and SQL25 marks
- Question 5Solution Development and Software Engineering7 marks
- Question 6Systems Technologies40 marks
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
2 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
INSTRUCTIONS AND INFORMATION
1. This question paper consists of SIX questions:
SECTION A: Multiple-choice questions (10)
SECTION B: System Technologies (20)
SECTION C: Communications and Network
Technologies (30)
SECTION D: Data and Information Management (25)
SECTION E: Solution Development (25)
SECTION F: Integrated Scenario (40)
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 2015) INFORMATION TECHNOLOGY P2 3
SECTION A: MULTIPLE-CHOICE QUESTIONS
QUESTION 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 number
(1.1–1.10) in the ANSWER BOOK.
1.1 Using someone else’s Internet connection without paying for it is also
called …
A piggybacking.
B theft.
C stalking.
D piracy. (1)
1.2 A computer system designed to gather information from a wide range of
sources, analyse it, and present it in summarised or graphical format that
aids in decision making is also called …
A DBMS.
B SQL.
C DSS.
D DMS. (1)
1.3 Solid state drives (SSDs) use a special type of … memory.
A electric
B mechanical
C magnetic
D electronic (1)
1.4 A small piece of software that has been designed to fix a specific bug in a
program is called a …
A patch.
B bugger.
C toolkit.
D doc. (1)
1.5 Fat clients …
A run most of their applications from their local hard drives.
B have lower hardware specifications.
C depend almost completely on a server to run applications.
D are powerful computers. (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
4 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
1.6 An intranet is a …
A network operating system.
B network filing system.
C private company network.
D global network. (1)
1.7 Spooling means to …
A send an interrupt request to the printer.
B send a print file to a file on the hard drive.
C swop pages between the virtual memory and the hard drive.
D print pages in reverse order. (1)
1.8 A value parameter …
A has a ‘var’ in front of it.
B receives information that is sent via arguments to the method.
C determines the largest value.
D is only used in procedures. (1)
1.9 Programs that add value and features to your system especially in terms of
maintenance and security are called …
A drivers.
B firewalls.
C anti-virus software.
D utilities. (1)
1.10 RSS …
A downloads audio or video files to your device so you can watch them
later.
B downloads any new content automatically without the user needing to
log on to those sites.
C collects data and instructions from memory.
D prevents you from receiving e-mails. (1)
TOTAL SECTION A: 10
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2015) INFORMATION TECHNOLOGY P2 5
SECTION B: SYSTEM TECHNOLOGIES
QUESTION 2
2.1 Computers are made up of many parts.
2.1.1 What is the term used to describe the above type of design? (1)
2.1.2 State TWO reasons why it is easier for computers to be made up of
many parts, rather than being one functioning unit. (2)
2.1.3 Where would you connect a new CPU to the motherboard? (1)
2.2 The CPU does almost all the work in a computer.
2.2.1 List the FOUR steps of the machine cycle. (4)
2.2.2 There are TWO factors of the CPU that can influence the
performance of a computer. These factors are speed and the core.
Describe each briefly. (4)
2.2.3 The two main categories of processors are 32-bit and 64-bit. Apart
from speed performance, name ONE other major difference
between 32-bit processors and 64-bit processors. (1)
2.2.4 Most CPUs nowadays have superscalar architecture. What does
superscalar mean? (2)
2.2.5 When a CPU is described as ‘Quad Core’, what type of processing
technique is used that cannot be used by a single processor? (1)
2.3 Software as a service (SaaS) has become more common.
2.3.1 Briefly explain the concept of SaaS. (2)
2.3.2 Differentiate between cloud-based apps and downloadable apps as
two different forms of SaaS. (2)
TOTAL SECTION B: 20
Copyright reserved Please turn over
Downloaded from hlayiso.com
6 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
SECTION C: COMMUNICATION AND NETWORKS TECHNOLOGIES
QUESTION 3
3.1 Life without Internet is unimaginable. To enable Internet connection, you
need a computer or any other Internet-enabled device, an Internet service
provider (ISP), Internet connection and software.
3.1.1 Define the term Internet. (2)
3.1.2 Describe what an ISP is. (2)
3.2 There are TWO main methods of connecting to the Internet, namely wired
through ADSL and wirelessly using cellular technology.
3.2.1 Give TWO advantages of using ADSL as opposed to cellular
connection. (2)
3.2.2 A modem and a router are associated with Internet connection.
Differentiate between these two devices. (2)
3.2.3 Does one need to purchase a separate modem and router when
setting up a home network? Supply a reason for your answer. (1)
3.2.4 WiMax is an upgrade on WiFi. Apart from the increase in speed,
how has WiMax improved over WiFi? (1)
3.3 When using a search engine such as Google, it happens that the
advertisements popping up are always applicable to your likes. How is this
possible? (2)
3.4 The Web has evolved from ‘version’ 1.0 to ‘version’ 2.0 and will evolve fully
into Web 3.0.
3.4.1 Web 1.0 was characterised by static web pages. What do we
mean by the term ‘static’ in this context? (1)
3.4.2 Apart from static web pages, what was the major shift from Web
1.0 to Web 2.0? (1)
3.4.3 Web 3.0 is often referred to as the ‘semantic web’. The semantic
web is a web of the future which will allow computers to conduct
automated searches for information. How will web pages need to
be modified to facilitate or allow this to evolve? (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2015) INFORMATION TECHNOLOGY P2 7
3.5 Today most computer devices are connected to some type of network,
from a Personal Area Network (PAN) to Wide Area Networks (WAN).
3.5.1 Explain what a Personal Area Network (PAN) is by referring to its
characteristics. (2)
3.5.2 Briefly explain what a Virtual Private Network (VPN) is. (3)
3.5.3 Instead of using VPN, name ONE other method you can use to get
the same result as you would through a VPN. (1)
3.5.4 What kind of network would it be if all the computers at your school
(computer labs, classes and the office) were connected to one
another? (1)
3.6 BitTorrent is a peer-to-peer protocol.
3.6.1 Give TWO benefits of using BitTorrent. (2)
3.6.2 Give TWO risks of using BitTorrent. (2)
3.6.3 Define a protocol in a network. (1)
3.6.4 Name the protocol that is used for communication over a network
or the Internet. (1)
3.6.5 What protocol will be used to send files between remote computers
that have an Internet connection? (1)
TOTAL SECTION C: 30
Copyright reserved Please turn over
Downloaded from hlayiso.com
8 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
SECTION D: DATA AND INFORMATION MANAGEMENT
QUESTION 4
4.1 A database management system (DBMS) is software that allows you to work
with electronic databases.
4.1.1 List the TWO categories into which DBMS software falls. (2)
4.1.2 What is a distributed database? (2)
4.1.3 Give an example of where a distributed database becomes
necessary. (1)
4.2 Study the extract below which is from a database capturing the data of
animals sent to different game parks and answer the questions that follow.
4.2.1 Which TWO anomalies exist in this table? Motivate your answers. (4)
4.2.2 Which field would you consider as redundant? Motivate your
answer. (2)
4.2.3 The table needs to be normalised.
(a) Supply TWO rules for normalisation to the first normal
form. (2)
(b) Normalise the table and divide it into THREE tables. All
original fields must appear in the tables. You may add
more fields if necessary. Clearly indicate the following
where possible:
- Primary key(s)
- Foreign key(s)
- Relationship between tables (7)
4.2.4 Write an SQL statement to display the Name, Price, Birth date and
Park of all the Elephants in the tblAnimals table, sorted in
alphabetical order by Name. (3)
4.2.5 Dumbo dies. Write an SQL statement to delete Dumbo from the
table tblAnimals. (2)
TOTAL SECTION D: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2015) INFORMATION TECHNOLOGY P2 9
SECTION E: SOLUTION DEVELOPMENT
QUESTION 5
5.1 The following is an example of a GUI designed to calculate the BMI of a
patient. Study the design and answer the questions that follow.
5.1.1 List FOUR ways in which the design layout and user-friendliness
can be improved. (4)
Copyright reserved Please turn over
Downloaded from hlayiso.com
10 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
5.1.2 Upon running the program, the following error message occurred.
(a) Why did this error message occur? (1)
(b) List ONE precaution against a message like this that you can
take while coding the program. (1)
5.2 Study the algorithm below and answer the questions that follow.
Line
1 Number1 7
2 Number2 19
3 If Number1 > Number2 then
4 If Number1 MOD Number2 = 0
5 Then Display
6 Else Display Error
7 If Number2 > Number1 then
8 If Number2 MOD Number1 = 0
9 Then Display
10 Else Display Error
5.2.1 What is the purpose of this piece of coding? (2)
5.2.2 Create appropriate messages to be displayed in lines 5 AND 6. (2)
5.2.3 Name the data type used for Number1 and Number2. (1)
5.2.4 If the value of Number2 changes to 0, what kind of error will
occur? (1)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2015) INFORMATION TECHNOLOGY P2 11
5.3 You need to create an application that will read the radius of a circle and
then display the circumference and area of the circle. The application must
make use of a class that will have the radius as attribute and have methods
to calculate the circumference and area.
5.3.1 Using a parameterised constructor, draw a class diagram to solve
the problem mentioned above. (3)
5.3.2 What is the purpose of a parameterised constructor? (2)
5.3.3 What is the difference between a private method and a public
method? (2)
5.3.4 Write a call statement to remove an object from the memory when
the program does not need the object any more. (2)
5.4 Give an example of an unconditional loop structure. (1)
5.5 Examine the following pseudo code and answer the question that follows.
Line
1. Place user input
2. Start loop from Place till NumElements – 1
3. ArrName[loop_value] ArrName[loop_value + 1]
4. NumElements NumElements – 1
Assume the original array is populated as follows:
arrName
Roeltin Jason Daniel Reuben Quintus Wian Jandré
[1] [2] [3] [4] [5] [6] [7]
Assume the input from the user is 3.
Redraw the diagram presenting the ArrName in your ANSWER BOOK.
Use the given algorithm and above information to populate the diagram as
it will be after the program is executed. (3)
TOTAL SECTION E: 25
Copyright reserved Please turn over
Downloaded from hlayiso.com
12 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
SECTION F: INTEGRATED SCENARIO
QUESTION 6
The executive committee (prefects) of your school wants to set up a small
network at school with a few computers. The use of it will be mainly to do their
planning, sharing of data and sharing of the printer. Of course they would want
Internet connectivity as well.
Joshua, also on the executive committee, is an IT student. He takes the lead in
this project.
6.1 The layout of the network is the first step. What is the term used to
describe the physical layout of a network? (1)
6.2 A wireless connection is not possible, so you will have to use cables. The
two options are UTP cables or fibre optic cables.
6.2.1 State TWO characteristics for each type of cabling mentioned
above. (Do NOT refer to the cost.) (4)
6.2.2 Which ONE of these two types of cable would you recommend that
the executive committee use? (1)
6.2.3 Analyse the physical limitations of the different communication
media, then list TWO physical limitations that would result in not
using WiFi as communication media. (2)
6.3 Apart from the medium used to transmit the data, an NIC (network interface
controller) is essential to set up a network.
6.3.1 Explain what an NIC is by referring to its function. (2)
6.3.2 Not all the computers have an NIC. List TWO ways in which this
problem can be solved. (2)
6.4 Using e-mail for communication between the committee members will be
helpful.
6.4.1 Unfortunately not all the members of the committee have access to
their own e-mail accounts. Distinguish between a web-based e-
mail and an ISP-based e-mail. (2)
6.4.2 When sending an e-mail through to all the members of the
committee, you need to add the e-mail addresses using Cc or Bcc.
Evaluate which one will be best. Justify your choice. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
(EC/SEPTEMBER 2015) INFORMATION TECHNOLOGY P2 13
6.5 One of the biggest threats to a computer room like this is the spread of
viruses.
6.5.1 Define a computer virus. (2)
6.5.2 Name the term used to describe any software that is written with
negative intentions. (1)
6.5.3 Pharming is a huge threat when it comes to using the Internet.
Briefly explain what Pharming is. (2)
6.5.4 A good anti-virus program can protect your computer against
most threats. There are, however, some types of threats that
can’t be avoided by using anti-virus software. In such cases, a
firewall is needed. What is the purpose of a firewall in terms of
computing? (2)
6.6 One of the complaints that has come to the executive committee’s table,
is that of cyber bullying. Joshua’s IT knowledge is needed. Explain what
cyber bullying is. (1)
6.7 Learners love social networking and do not always realise how much of
an impact social networking can have on them.
6.7.1 The life of a social engineer just gets easier by the minute. What
is a social engineer? (2)
6.7.2 Using social networking can be time consuming. List any THREE
practical ways in which you can reduce the number of
interruptions in your daily life caused by social networking. (3)
6.8 Some of the students are not comfortable with using computers or do not
have computers at home, while the other are very comfortable and have
been working on computers from a very young age. What is this ‘gap’
called? (1)
6.9 Joshua suggests the use of cloud storage. List TWO disadvantages of
cloud computing. (2)
6.10 There is some confusion between the terms virtualisation and virtual
memory. Clear the confusion by defining these two terms. (2)
Copyright reserved Please turn over
Downloaded from hlayiso.com
14 INFORMATION TECHNOLOGY P2 (EC/SEPTEMBER 2015)
6.11 The treasurer of the executive committee needs to make Internet banking
payments.
6.11.1 List TWO benefits of using Internet banking. (2)
6.11.2 It is important that this person is able to recognise a secure
website. List TWO ways to identify a secure website. (2)
6.12 Explain how caching increases the processing speed of the processor. (2)
TOTAL SECTION F: 40
GRAND TOTAL: 150
Copyright reserved Please turn over
Study this subject
Recommended for this subject
_hlayiso.com_--ede4321e-b5a0-403e-a86f-4199fa522997/v1-855a626a687615377d16/card.webp)
Memorandum
Information Technology Grade 12 P2 2015 Memo (Eng)

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2015 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2015 QP
_hlayiso.com_--053b6720-3be0-4739-8737-7f0b610b5f60/v1-3d19c9dfc8e924c4cf55/card.webp)
Question paper
Information Technology Grade 12 P2 NSC November 2015 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
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