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

- Page: https://www.hlayiso.com/library/information-technology-p2-nov-2018-eng/0133a985-44bc-478a-aa08-e07d80c54ec1
- Updated: 2026-09-27
- Subject: Information Technology
- Grade: Grade 12
- Document type: Question paper
- Year: 2018
- Exam period: NSC November Exam
- Paper: 2
- Curriculum: CAPS
- Pages: 16

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 NSC November 2018 QP](https://www.hlayiso.com/library/information-technology-p2-nov-2018-eng/0133a985-44bc-478a-aa08-e07d80c54ec1)

## About this document

Information Technology · Grade 12 · NSC November Exam · 2018. Question paper, 16 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

                        INFORMATION TECHNOLOGY P2

                                  NOVEMBER 2018

MARKS: 150

TIME: 3 hours

                       This question paper consists of 16 pages.

Copyright reserved                                                 Please turn over

### Page 2

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

### Page 3

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

### Page 4

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

### Page 5

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

### Page 6

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

### Page 7

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

### Page 8

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

### Page 9

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

### Page 10

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

### Page 11

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

### Page 12

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

### Page 13

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         c0
           3         x  PIN
           4         Repeat
           5               x  x / 10
           6               cc+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

### Page 14

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

### Page 15

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

### Page 16

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

## Related documents

- [Information Technology P2 Nov 2018 Afr](https://www.hlayiso.com/library/information-technology-p2-nov-2018-afr/6497b497-5554-43a7-9de1-f30911edbe63) — Information Technology · QP · 2018 · Afr
- [Information Technology P2 Nov 2018 FINAL Memo Afr](https://www.hlayiso.com/library/information-technology-p2-nov-2018-final-memo-afr/e606bf7e-39ef-42a7-908b-0193e164cc67) — Information Technology · Memo · 2018 · Afr
- [Information Technology P2 May June 2018 Afr](https://www.hlayiso.com/library/information-technology-p2-may-june-2018-afr/6b269923-729c-48cc-82f7-9ddd5ac3d72b) — Information Technology · QP · 2018 · Afr
- [Information Technology P2 Nov 2022 Eng](https://www.hlayiso.com/library/information-technology-p2-nov-2022-eng/822832f6-7a60-4201-99d7-28816084f46c) — Information Technology · QP · 2022 · Eng
- [Information Technology P2 Nov 2019 Afr](https://www.hlayiso.com/library/information-technology-p2-nov-2019-afr/7123ab7f-cc2d-49bc-92d0-39b6ac84715e) — Information Technology · QP · 2019 · Afr
- [Information Technology P2 Nov 2017 Afr](https://www.hlayiso.com/library/information-technology-p2-nov-2017-afr/7e4f4410-243e-4a96-a17a-5e5ad962f3f3) — Information Technology · QP · 2017 · 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.
