Information Technology Grade 12 P2 NSC November Mock 2026 QP

Mock hlayiso mock exams Practice Series: Grade 12 NSC Preparation WWW.HLAYISO.COM NATIONAL SENIOR CERTIFICATE GRADE 12 INFORMATION TECHNOLOGY P2 MOCK EXAMINATION 2026 MARKS: 150 TIME: 3 hours This question paper consists of 15 pages. Copyright reserved Please turn over

Information Technology/P2 2 Hlayiso/Mock 2026 NSC Mock INSTRUCTIONS AND INFORMATION 1. This question paper consists of SIX sections: SECTION A: Short Questions (20) SECTION B: Systems Technologies (25) SECTION C: Communication and Network Technologies (25) SECTION D: Data and Information Management (20) SECTION E: Solution Development (30) SECTION F: Integrated Scenario (30) 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

Information Technology/P2 3 Hlayiso/Mock 2026 NSC Mock 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.10) in the ANSWER BOOK, e.g. 1.1.11 D. 1.1.1 Which ONE of the following is an example of system software? A Word processor B Device driver (1) C Web browser D Photo editor 1.1.2 The component of the CPU that performs calculations and logical comparisons is the … A control unit. B register. (1) C cache. D arithmetic logic unit (ALU). 1.1.3 Which ONE of the following protocols is used to transfer web pages securely? A HTTP B FTP (1) C HTTPS D SMTP 1.1.4 A … is a network device that connects different networks and determines the best path along which to send data packets. A router B switch (1) C wireless access point D network interface card 1.1.5 Which ONE of the following data types is the most suitable to store a cellphone number such as 0821234567 in a database? A Integer B Real (1) C Text/String D Boolean 1.1.6 Which ONE of the following Delphi expressions will return the value 3? A Trunc(17 / 4) B 17 MOD 5 (1) C Round(17 / 5 + 0.5) D 17 DIV 5 Copyright reserved Please turn over

Information Technology/P2 4 Hlayiso/Mock 2026 NSC Mock 1.1.7 Malware that disguises itself as useful, legitimate software is known as a … A worm. B botnet. (1) C Trojan horse. D cookie. 1.1.8 Which ONE of the following is a characteristic of Web 2.0? A User-generated content and collaboration B Static web pages that can only be read (1) C Intelligent agents that understand the meaning of data D Web pages that can only be downloaded using FTP 1.1.9 Which ONE of the following SQL statements will remove records from a table? A REMOVE FROM tblSales WHERE Amount < 100 B DELETE FROM tblSales WHERE Amount < 100 (1) C DELETE * tblSales WHERE Amount < 100 D DROP tblSales WHERE Amount < 100 1.1.10 The following Delphi statements have been executed: sWord := 'FESTIVAL'; sNew := Copy(sWord, 3, 4); What is the value of sNew? A ’ESTI’ B ’STI’ (1) C ’TIVA’ D ’STIV’ Copyright reserved Please turn over

Information Technology/P2 5 Hlayiso/Mock 2026 NSC Mock 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.5) in the ANSWER BOOK, e.g. 1.2.6 Computer. 1.2.1 The time delay between sending a request over a network and receiving a response (1) 1.2.2 Software of which the source code is freely available to be viewed, modified and distributed (1) 1.2.3 A small text file that a website stores on a user’s computer to remember information about the user (1) 1.2.4 A rule which ensures that every foreign key value refers to an existing primary key value in the related table (1) 1.2.5 The process of finding and correcting errors in a program (1) 1.3 Indicate whether the following statements are TRUE or FALSE. Choose the answer and write ’true’ or ’false’ next to the question numbers (1.3.1 to 1.3.5) in the ANSWER BOOK. Correct the statement if it is false by changing the underlined word/phrase. NOTE: • Do NOT simply use the word ’NOT’ to change the statement. • NO marks will be awarded if only FALSE is provided as an answer. 1.3.1 A compiler translates and executes source code one line at a time. (1) 1.3.2 A solid-state drive (SSD) has no moving parts. (1) 1.3.3 A MAC address is assigned to a device by a DHCP server each time the device connects to a network. (1) 1.3.4 In a one-to-many relationship, the foreign key is placed in the table on the many side of the relationship. (1) 1.3.5 Phishing is an attack in which a server is flooded with requests so that legitimate users cannot access it. (1) TOTAL SECTION A: 20 Copyright reserved Please turn over

Information Technology/P2 6 Hlayiso/Mock 2026 NSC Mock SECTION B: SYSTEMS TECHNOLOGIES QUESTION 2 SCENARIO The Indalo Arts Festival is a ten-day festival of music, theatre and visual arts held every year in Mbombela, Mpumalanga. The festival office manages ticket sales, venues and performers throughout the year. Tickets are sold online and at a ticket office, and festival staff use mobile devices at the venues. The IT team of the festival is responsible for the computers, the network, the website and the festival app. 2.1 The festival office bought new desktop computers with the following specifications: Processor 6-core CPU, 12 threads, 3.8 GHz, 18 MB cache Memory 16 GB DDR5 RAM Storage 512 GB NVMe solid-state drive (SSD) Graphics Integrated graphics Operating system Windows 11 2.1.1 Explain what is meant by a multi-core processor. (2) 2.1.2 The processor supports multithreading. Explain the concept multithreading. (2) 2.1.3 State TWO advantages of an SSD compared to a hard disk drive (HDD) for the office computers. (2) 2.1.4 Explain how cache memory improves the performance of a computer. (2) 2.2 The operating system manages the resources of a computer. 2.2.1 Explain why a computer becomes slow when the operating system relies heavily on virtual memory. (2) 2.2.2 Apart from memory management, name TWO other functions of an operating system. (2) 2.3 Barcode scanners and receipt printers were connected to the computers at the ticket office. Each of these devices was ready to use as soon as it was plugged in. Explain the concept plug-and-play. (2) 2.4 Festival staff use tablets at the venue gates to scan the QR codes on e-tickets. 2.4.1 Give TWO reasons why tablets are suitable devices to scan e-tickets at venue gates. (2) 2.4.2 Name the input device on a tablet that is used to scan a QR code. (1) Copyright reserved Please turn over

Information Technology/P2 7 Hlayiso/Mock 2026 NSC Mock 2.4.3 The tablets must be used for long periods during the day. Suggest ONE way in which the battery power of the tablets can be conserved. (1) 2.5 The festival subscribes to an online graphic design application on a monthly basis. The application is accessed through a web browser. This is an example of SaaS. 2.5.1 Expand the abbreviation SaaS. (1) 2.5.2 Give TWO advantages of SaaS for the festival. (2) 2.6 The old computers that were replaced must be disposed of. State TWO ways in which the festival can dispose of the old computers in an environmentally responsible manner. (2) 2.7 The festival office regularly experiences power interruptions due to load reduction. Recommend a device that will allow the computers to be shut down safely when the power fails, and explain how this device will help. (2) TOTAL SECTION B: 25 Copyright reserved Please turn over

Information Technology/P2 8 Hlayiso/Mock 2026 NSC Mock SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES QUESTION 3 SCENARIO The festival headquarters (HQ) has a wired network that connects the computers in the office. Festival venues across the town must be connected to the HQ, and visitors are provided with free Wi-Fi in the festival village. Selected performances are streamed live over the internet. 3.1 The diagram below shows the network at the festival HQ. PC PC PC PC PC Server A B Internet Printer C Laptop Tablet 3.1.1 Identify the physical topology of the network. (1) 3.1.2 Identify device A that connects all the computers in the office. (1) 3.1.3 Identify device B that connects the HQ network to the internet. (1) 3.2 Device C provides a Wi-Fi hotspot. Similar hotspots have been set up in the festival village for visitors. 3.2.1 What is a hotspot? (2) 3.2.2 State TWO security risks for visitors who use a public Wi-Fi hotspot. (2) 3.2.3 Explain how a VPN will protect the data of a visitor who uses a public hotspot. (2) 3.3 Identify the type of network that will be created when the networks at venues across the town are connected to the network at the HQ. (1) 3.4 Selected performances are streamed live over the internet. 3.4.1 Explain why video must be compressed before it is streamed. (2) 3.4.2 Differentiate between lossy and lossless compression. (2) 3.4.3 Give TWO factors that influence the quality of a live stream received by viewers at home. (2) Copyright reserved Please turn over

Information Technology/P2 9 Hlayiso/Mock 2026 NSC Mock 3.5 Photographs and videos of the festival are stored in cloud storage. State TWO disadvantages of cloud storage for the festival. (2) 3.6 E-tickets are bought on the festival website. The website displays a padlock icon in the address bar of the browser. 3.6.1 Explain the purpose of a digital certificate. (2) 3.6.2 Name the protocol that is used to encrypt the data sent between the browser and the web server. (1) 3.7 The festival sends an e-mail newsletter to more than 5 000 subscribers. Explain why the subscribers’ e-mail addresses should be entered in the BCC field of the e-mail. (2) 3.8 Explain the function of a DHCP server on the HQ network. (2) TOTAL SECTION C: 25 Copyright reserved Please turn over

Information Technology/P2 10 Hlayiso/Mock 2026 NSC Mock SECTION D: DATA AND INFORMATION MANAGEMENT QUESTION 4 The bookings for shows at the festival were initially stored in a single table called tblBookings. Examples of records in the table are shown below. BookingID CustomerName CustomerEmail ShowTitle Venue ShowDate TicketPrice NumTickets 1 Ayanda Zulu ayanda.z@mailbox.co.za Marimba Nights Town Hall 2026/07/03 R120.00 2 2 Pieter Botha pbotha@webmail.co.za Jozi Jazz Trio Civic Theatre 2026/07/04 R150.00 4 3 Ayanda Zulu ayanda.z@mailbox.co.za Jozi Jazz Trio Civic Theatre 2026/07/04 R150.00 1 4 Fatima Patel fatimap@inbox.co.za Marimba Nights Town Hall 2026/07/03 R120.00 3 5 Pieter Botha pbotha@webmail.co.za Indalo Comedy Hour Studio 2 2026/07/05 R90.00 2 4.1 Study the table above and answer the questions that follow. 4.1.1 State TWO problems that are caused by the data redundancy in the tblBookings table. (2) 4.1.2 Name and explain the anomaly that will occur if the ticket price of the show ’Jozi Jazz Trio’ changes. (2) 4.1.3 The tblBookings table must be split into three tables to remove the redundancy. The tables tblCustomers and tblShows have been designed as shown below. tblCustomers tblShows tblBookings CustomerID (PK) ShowID (PK) CustomerName ShowTitle CustomerEmail Venue ShowDate TicketPrice Redraw the tables in your ANSWER BOOK and complete the design as follows: • Fill in ALL the fields required in the tblBookings table, indicating the primary key and the foreign key(s). • Show the relationships between the tables, including the type of each relationship. (6) 4.2 Name TWO different validation checks that could be applied to the NumTickets field when a booking is captured. (2) 4.3 The festival collects large volumes of data from ticket sales and the use of the festival app. 4.3.1 Explain what is meant by data mining. (2) 4.3.2 Give ONE example of how data mining could help the festival to plan the programme for the next festival. (1) 4.4 The festival’s database management system (DBMS) keeps an audit trail. Explain the purpose of an audit trail. (2) 4.5 The database is distributed over a server at the HQ and a server at the ticket office. Give TWO advantages of a distributed database for the festival. (2) Copyright reserved Please turn over

Information Technology/P2 11 Hlayiso/Mock 2026 NSC Mock 4.6 Give ONE example of metadata for the ShowDate field. (1) TOTAL SECTION D: 20 Copyright reserved Please turn over

Information Technology/P2 12 Hlayiso/Mock 2026 NSC Mock SECTION E: SOLUTION DEVELOPMENT QUESTION 5 5.1 Give the value of the variable in EACH of the following Delphi statements: 5.1.1 iResult := 47 MOD 10 DIV 2; (1) 5.1.2 iLength := Length('Arts Festival'); (1) 5.1.3 bResult := NOT (5 > 3) OR (2 = 2); (1) 5.2 The festival lasts five days. The following code was written to calculate the average number of tickets sold per day: Line 1 var Line 2 iDay, iTotal, iAverage: Integer; Line 3 begin Line 4 iTotal := 0; Line 5 for iDay := 1 to 4 do Line 6 iTotal := iTotal + StrToInt(InputBox('Sales', 'Tickets sold on day ' + IntToStr(iDay), '')); Line 7 iAverage := iTotal / 5; Line 8 ShowMessage('Average: ' + IntToStr(iAverage)); Line 9 end; 5.2.1 Line 7 will cause a syntax (compilation) error. Explain why this error occurs and suggest a correction. (2) 5.2.2 The code contains a logical error. Identify the line number of the logical error and explain how to correct it. (2) 5.2.3 Give an example of input in Line 6 that will cause a runtime error and explain why the error occurs. (2) 5.3 The festival app uses a class called TPerformance. The UML diagram of the class is shown below. TPerformance - fTitle: String - fArtist: String - fDuration: Integer - fTicketsSold: Integer + Create(sTitle, sArtist: String; iDuration: Integer) + getTitle: String + addTickets(iNum: Integer) + calcIncome(rPrice: Real): Real + toString: String 5.3.1 Identify ONE accessor method in the UML diagram. (1) 5.3.2 All the attributes are private. Explain why attributes are declared as private. (2) Copyright reserved Please turn over

Information Technology/P2 13 Hlayiso/Mock 2026 NSC Mock 5.3.3 Write Delphi code for the method addTickets that increases the value of the fTicketsSold attribute by the value of the parameter, but only if the parameter value is greater than zero. (3) 5.3.4 Write a Delphi statement to instantiate an object called objShow for the performance ’Marimba Nights’ by the artist ’Thando and the Keys’ with a duration of 90 minutes. (2) 5.4 Study the following segment of Delphi code: iNum := 2026; iSum := 0; sOut := ''; while iNum > 0 do begin iDigit := iNum MOD 10; iSum := iSum + iDigit; sOut := sOut + IntToStr(iDigit); iNum := iNum DIV 10; end; 5.4.1 Copy and complete the trace table below in your ANSWER BOOK to show the values of the variables while the code is executed. iNum iNum > 0 iDigit iSum sOut 2026 0 ” (4) 5.4.2 Describe the purpose of the code segment. (1) 5.5 After each show, audience members can rate the show from 1 to 5 stars on the festival app. The ratings for a show are stored in an array called arrRatings. The variable iCount contains the number of ratings stored in the array. Write an algorithm that uses a second array called arrFreq, with indices from 1 to 5, to do the following: • Count how many times each rating (1 to 5) was given. • Display each rating and the number of times it was given. • Determine and display the rating that was given the most times. (Assume that there is only one such rating.) (8) TOTAL SECTION E: 30 Copyright reserved Please turn over

Information Technology/P2 14 Hlayiso/Mock 2026 NSC Mock SECTION F: INTEGRATED SCENARIO QUESTION 6 SCENARIO The organisers of the Indalo Arts Festival want to use technology to improve the experience of visitors and to keep the festival safe. A festival app, an online ticketing system and cashless payments will be used this year. The IT team must also protect the festival’s systems and the personal information of visitors. 6.1 The festival app shows visitors the venues closest to them. 6.1.1 Name TWO technologies that a smartphone can use to determine its location. (2) 6.1.2 State ONE privacy concern of location-based services. (1) 6.2 An AI chatbot on the festival website answers questions from visitors. 6.2.1 Give TWO advantages of using an AI chatbot for the festival. (2) 6.2.2 The chatbot sometimes gives answers that sound convincing but are incorrect. Explain why it is important that the festival checks the information that the chatbot provides. (2) 6.3 The ticket website was the target of a distributed denial-of-service (DDoS) attack on the day that tickets went on sale. 6.3.1 Explain how a DDoS attack works. (2) 6.3.2 Suggest TWO measures that the festival can take to reduce the impact of a DDoS attack. (2) 6.3.3 Ticket resellers used automated software (bots) to buy large numbers of tickets. Explain how a CAPTCHA can prevent this. (2) 6.4 Each e-ticket contains a unique QR code. Explain how scanning the QR code against a central database prevents a copy of the same e-ticket from being used twice. (2) 6.5 The festival promotes its events on social media. 6.5.1 Explain the term digital footprint. (2) 6.5.2 A post that a popular show has been cancelled went viral on social media. Give ONE way in which visitors can verify whether the post is fake news. (1) 6.6 Some visitors record complete performances and upload the videos to video-sharing websites. 6.6.1 Explain why this may be an infringement of copyright. (2) 6.6.2 The festival publishes its own photographs under a Creative Commons licence. What does this mean? (1) Copyright reserved Please turn over

Information Technology/P2 15 Hlayiso/Mock 2026 NSC Mock 6.7 Visitors receive wristbands that use NFC technology to pay for food and drinks at the festival. 6.7.1 Expand the abbreviation NFC. (1) 6.7.2 Give TWO advantages of cashless wristbands for the festival. (2) 6.7.3 State ONE disadvantage of cashless wristbands for visitors. (1) 6.8 Sensors that are connected to the internet count the number of people entering and leaving each venue. 6.8.1 Explain the concept Internet of Things (IoT). (2) 6.8.2 Give ONE way in which these sensors can improve the safety of visitors. (1) 6.9 The festival collects the personal information of visitors when they buy tickets. State TWO responsibilities of the festival in terms of the Protection of Personal Information Act (POPIA). (2) TOTAL SECTION F: 30 GRAND TOTAL: 150 Copyright reserved