# 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.

- Page: https://www.hlayiso.com/library/inf-tech-p2-gr12-qp-sept2016-engl/6bdce437-24ff-4023-b961-050f9960771a
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2016
- Exam period: Eastern Cape Mock Exam
- Paper: 2
- Curriculum: CAPS
- Pages: 15

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Library](https://www.hlayiso.com/library) › [Grade 12](https://www.hlayiso.com/library/grade-12) › [Information Technology](https://www.hlayiso.com/library/grade-12/information-technology) › [Information Technology Grade 12 P2 Eastern Cape Mock 2016 QP](https://www.hlayiso.com/library/inf-tech-p2-gr12-qp-sept2016-engl/6bdce437-24ff-4023-b961-050f9960771a)

## About this document

Information Technology · Grade 12 · Eastern Cape Mock Exam · 2016. Question paper, 15 pages. Read online or download the PDF.

Read it free online on the page above; download the PDF from there.

## Document text

Text extracted from the PDF. Layout, diagrams and tables may not survive extraction.

### Page 1

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.

### Page 2

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

### Page 3

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

### Page 4

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

### Page 5

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

### Page 6

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

### Page 7

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

### Page 8

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

### Page 9

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

### Page 10

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

### Page 11

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

### Page 12

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

### Page 13

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

### Page 14

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

### Page 15

Downloaded from hlayiso.com

## Related documents

- [INFT GR12 P2 MEMO SEPT2016 Engl](https://www.hlayiso.com/library/inft-gr12-p2-memo-sept2016-engl/f67a1ec0-17a6-4ad5-9845-4b08f2fe4d8b) — Information Technology · Memo · 2016
- [INF TECH P2 GR12 MEMO SEPT2016 Afr](https://www.hlayiso.com/library/inf-tech-p2-gr12-memo-sept2016-afr/16a8152b-c801-4b1c-a324-f7f1abdb51e5) — Information Technology · Memo · 2016 · Afr
- [ENGHL P1 GR12 QP ENG SEPT2016](https://www.hlayiso.com/library/enghl-p1-gr12-qp-eng-sept2016-1/6f6966c3-a4a0-4de2-8abc-b82595b1e6b7) — Information Technology · QP · 2016 · Eng
- [IT P2 GR12 QP SEPT2022 Afrikaans](https://www.hlayiso.com/library/it-p2-gr12-qp-sept2022-afrikaans/3392f845-8547-4e23-b73c-910c59ca4b2b) — Information Technology · QP · 2022 · Afr
- [IT P2 GR12 QP SEPT2022 English](https://www.hlayiso.com/library/it-p2-gr12-qp-sept2022-english/59a4dc5f-1ee1-44b9-b838-76b7e9322abb) — Information Technology · QP · 2022 · Eng
- [IT P2 GR12 QP SEPT2020 Afrikaans](https://www.hlayiso.com/library/it-p2-gr12-qp-sept2020-afrikaans/bce79554-ac5b-49c0-8c46-7d49632baa53) — Information Technology · QP · 2020 · Afr

## More from Grade 12 Information Technology

- [Information Technology P1 May-June 2025 MG Eng](https://www.hlayiso.com/library/information-technology-p1-may-june-2025-mg-eng/109c2e1d-bc20-46d3-ac02-c08c05ad9c78) — Memo · 2025 · Eng
- [IT P1 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p1-memo-gr12-sept-2024-english/8994aed2-83ec-413e-b7dc-b0d0b93b82f4) — Memo · 2024 · Eng
- [IT P2 MEMO GR12 SEPT 2024 English](https://www.hlayiso.com/library/it-p2-memo-gr12-sept-2024-english/4d74acb4-cb8b-4fd3-874f-4801fbcb8f44) — Memo · 2024 · Eng
- [IT P1 MEMO GR12 SEPT2023 Afrikaans](https://www.hlayiso.com/library/it-p1-memo-gr12-sept2023-afrikaans/7ffdb7c3-1881-43da-8d8a-96ea3ff87451) — Memo · 2023 · Afr
- [IT P2 GR12 MEMO SEPT2023 Afrikaans](https://www.hlayiso.com/library/it-p2-gr12-memo-sept2023-afrikaans/88ad2758-42f6-43df-a80a-288b5f4cff9f) — Memo · 2023 · Afr
- [IT P2 GR12 MEMO SEPT2023 English](https://www.hlayiso.com/library/it-p2-gr12-memo-sept2023-english/41fa8299-d258-40e9-8c8b-a3ce984eef54) — Memo · 2023 · Eng

## Collection

- [Grade 12 past papers](https://www.hlayiso.com/grade-12/past-papers)

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.
