Skip to content

Information Technology Grade 12 P2 GAU Prelim 2021 QP

Question paperInformation TechnologyGrade 12202114 pages

Grade 12 Information Technology Paper 2 question paper from the GAU Prelim 2021, 14 pages. Read online or get the free PDF download, memo linked when available.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

GAU Prelim 2021

Questions in this paper

Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com PREPARATORY EXAMINATION 2021 GRADE 12 QUESTION PAPER SUBJECT : IT PAPER 2 TIME : 3 HOURS MARKS : 150 Date : 23 September 2021 Session : 2 - Afternoon This question paper consists of 6 questions and 14 pages (including cover page).
Downloaded from P2hlayiso.com GRADE 12 INFORMATION TECHNOLOGY INSTRUCTIONS AND INFORMATION 1. This question paper consists of SIX sections: SECTION A: Short questions (15) SECTION B: System Technologies (28) SECTION C: Communication and Network Technologies (22) SECTION D: Data and Information Management (25) SECTION E: Solution Development (25) SECTION F: Integrated Scenario (35) 2. Read ALL the questions carefully. 3. Answer ALL the questions. 4. The mark allocation is usually an indication of the number of facts/reasons required. 5. Number questions correctly according to the numbering system used in this question paper. 6. Write neatly and legibly. Page 2 of 14 Please turn over
Downloaded from P2hlayiso.com GRADE 12 INFORMATION TECHNOLOGY 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 number (1.1.1–1.1.5) in the ANSWER BOOK, for example 1.1.6 D. 1.1.1 Which ONE of the following is the most likely reason why all files frequently disappear from the same USB flash drive? A The flash drive was connected to a USB 3.0 port. B Firewall software. C The flash drive is 'Read Only’. D The files were hidden by a virus. (1) 1.1.2 The copyright law is NOT broken when you A copy music from your friend's computer to your MP3 player. B borrow a CD from a friend and copy it to your computer. C find and download music from the Internet. D copy your own CD to play on your MP3 player. (1) 1.1.3 Which ONE of the following refers to an encryption process used to authenticate the identity of the sender of an e-mail message? A Digital certificate B Digital divide C Digital handshake D Digital signature (1) 1.1.4 Which loop structure will be most suitable to detect the information of a customer in the database of a large company with over 100 000 records? A Single loop B Conditional loop C Unconditional loop D Never ending loop (1) 1.1.5 A hardware interrupt is A a method used by peripherals to gain the CPU’s attention when they need to communicate. B used to stop a printer when it continues printing an unwanted print job. C used by the memory of a computer to interrupt (or stop) a peripheral when communicating with the CPU. D the process that occurs when the power supply unit fails and the computer stops working. (1) [5] Page 3 of 14 Please turn over
Downloaded from P2hlayiso.com GRADE 12 INFORMATION TECHNOLOGY 1.2 Indicate whether the following statements are TRUE or FALSE. If the statement is false, you must replace the underlined word so that the statement will be true. (You can not simply add the word “NOT” to make the statement true). 1.2.1 A collection of 8 bits is a byte. (1) 1.2.2 A Trojan is a collection of programs designed to use administrator rights to gain control of a computer for dangerous purposes. (1) 1.2.3 A compiler executes programming instructions one line at a time until it comes across an error. (1) 1.2.4 Bandwidth is the amount of data that can be transferred from one point to another in a given period of time. (1) 1.2.5 A Keylogger is an advertisement that opens a new window in the web browser when the user is visiting the website. (1) [5] 1.3 Give ONE word/term for each of the following descriptions. Write only the word/term next to the question number (1.3.1–1.3.5) in the ANSWER BOOK. 1.3.1 Software that is stored permanently on the ROM chip of a mobile device to control the basic operation of the device. (1) 1.3.2 Design, use and dispose of technology in an environmentally friendly way. (1) 1.3.3. The posting of short text entries (140 characters or less) usually via a cell phone or smartphone. (1) 1.3.4 A strategy or technology used to ensure that a website will be placed high on the list in the search results of a search engine. (1) 1.3.5 A website that is regularly updated in chronological order with news and events. (1) [5] TOTAL SECTION A: [15] Page 4 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 SECTION B: SYSTEM TECHNOLOGIES QUESTION 2 SCENARIO: The staff at the Kruger Park has an office with computers. The computers are out of date and are due for upgrade. Advise them on the best solution by answering the following questions. 2.1 Most of the computers that you have tested are extremely slow. 2.1.1 Name TWO hardware components that can cause low processing speeds. (2) 2.1.2 What is the term used which enables hardware components on computers to be upgraded and replaced instead of purchasing an entire new computer? (1) 2.2 Why would it be better to use a dedicated graphics card rather than an on-board graphics card on the motherboard of a slow functioning computer? (2) 2.3 A computer can not function without RAM. 2.3.1 Explain what RAM is. Do NOT refer to the function. (2) 2.3.2 What is the function of RAM in a computer? (2) 2.3.3 What type of connection is found between the CPU and RAM that enables faster data transfer? (1) 2.3.4 Give TWO reasons why RAM is limited in a computer. (2) 2.4 The computers and devices all use either hard drives or Solid State Drives (SSDs). Give TWO reasons why HDDs are still preferred over SSDs in computers. (2) 2.5 Many peripheral devices are connected to the computer via USB ports. Name TWO ports, other than the USB port, that can be used to connect a digital video camera to a computer. (2) 2.6 Driver software must be loaded onto some computers. 2.6.1 Define a driver in the context of computing. (2) 2.6.2 What is meant by the term standard driver? (1) 2.7 Describe the following processing techniques. 2.7.1 Multithreading. (2) 2.7.2 Multitasking. (2) Page 5 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 2.8 Cloud computing is the new buzzword. 2.8.1 What is a cloud application? (1) 2.8.2 Give TWO reasons for using SaaS (Software as a Service) instead of standard desktop software. (2) 2.8.3 What is the difference between Cloud backup and sinchronisation of files in the cloud? (2) TOTAL SECTION B: [28] Page 6 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 SECTION C: COMMUNICATION AND NETWORK TECHNOLOGIES QUESTION 3 3.1 Setting up a network in a computer centre has its challenges and advantages. 3.1.1 Describe a network. (2) 3.1.2 Explain what the difference between a router and a switch is. (2) 3.2 The following diagram is an example of the layout of the network. Answer the questions that follows. 3.2.1 What type of network topology is displayed in the image above? (1) 3.2.2 Give ONE advantage of using UTP cables. (1) 3.2.3 What is the function of the NIC (network interface controller/card)? (1) 3.3 Visitors to the game reserve make electronic payments by using the internet. 3.3.1 Name TWO safety features that must be visible on the web site for the visitors to be sure that their transactions will be secure. (2) 3.3.2 Briefly explain how secure socket layer (SSL) can ensure that private electronic communication takes place. (2) 3.3.3 Identity theft can easily occur with unsecure URLs. Distinguish between phishing and pharming attacks. (2) 3.4 The network administrator is responsible for the regular backup of the centre’s data. 3.4.1 Give TWO other duties of the network administrator. (2) 3.4.2 When referring to user rights, what is the difference between an administrator and a standard user? (2) Page 7 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 3.5 The following Internet protocol (IP) address has been assigned to one of the computers in the computer centre: 3.5.1 What is an IP address? (1) 3.5.2 Why should another computer on the same network (LAN) not be assigned the same IP address? (1) 3.6 A wireless access point has been installed for the visitors to enable them to have internet connectivity. 3.6.1 Explain a possible problem with sharing the Internet access. (1) 3.6.2 The passwords for all the users are generated using the initials of the user and his/her employee number, for example BT345. Critically comment on the generated passwords in terms of the requirements for strong passwords. (2) TOTAL SECTION C: [22] Page 8 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 SECTION D: DATA AND INFORMATION MANAGEMENT QUESTION 4 Visitors are placed in a database to record where they stay. 4.1 Explain what the term primary key refers to in a database table. (2) 4.2 The foreign key is used to link two tables. What is the main difference between the foreign key field in a table and other fields in that table. (1) 4.3 Data integrity can be split into two broad areas. 4.3.1 Explain what physical data integrity refers to. (2) 4.3.2 Give TWO examples of practical issues that physical data integrity can refer to. (2) 4.3.3 Give TWO solutions (programming options excluded) that can help ensure the physical integrity of data. (2) 4.4 The GIGO principle is essential when managing and protecting data. 4.4.1 Describe the difference between data validation and data verification. (2) 4.4.2 Explain the meaning of the GIGO principle. (Simply giving the meaning of the abbreviation is not enough to obtain full marks) (1) 4.5 An audit trail is used when the database contains sensitive information. 4.5.1 What is the purpose of an audit trail? (2) 4.5.2 Name TWO disadvantages of using an audit trail. (2) 4.6 A database with the table, tblRangers has been designed: tblRangers Field’s Name DataType PK RangerID 4.6.1 Initial and Surname Text Appointment date 4.6.2 Use the information provided in tblRangers to suggest a suitable data type for EACH of the following fields: 4.6.1 RangerID (1) 4.6.2 Appointment date (1) Page 9 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 4.7 A report with an alphabetical list of rangers, sorted according to their surnames, is required. 4.7.1 Evaluate the structure of the tblRangers table. State the problem that will arise when attempting to generate the report. (2) 4.7.2 Explain how normalisation can prevent the problem in 4.7.1. (1) 4.8 The data in the database can be used for data mining. Explain what data mining is. (2) 4.9 SQL queries are used to obtain information from the database. Explain how SQL injection can be used as a hacking tool. (2) TOTAL SECTION D: [25] Page 10 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 SECTION E: SOLUTION DEVELOPMENT QUESTION 5 The following class diagram (UML diagram) shows the attributes and methods that are used to create the visitor object for the game reserve. VISITOR FIELDS METHODS - fVisitorID : string + Constructor(ID, Name, Num) - fName : string + DetermineAge : Integer - fContactNumber : String + ………5.2……… - fGender : Char + DetermineGender ……5.3..... - fFullTime : Boolean + toString:string; 5.1 Explain the difference between the public and private declarations in relation to OOP. (2) 5.2 Consider the following: • The constructor has parameters to initialise the attributes fVisitorID, fName and fContactNumber. • The gender is determined by the DetermineGender method from the ID of the employee. Which mutator method(s) must be added to provide value(s) for the remaining attributes after the constructor has instantiated the object? (2) 5.3 To determine the gender of an employee, the seventh character is extracted from the ID and tested against a set of conditions. • Write ONLY the definition statement of the DetemineGender method. (2) 5.4 Answer the following question related to the VISITOR class diagram. 5.4.1 What is the function of a toString method? (2) 5.5 You received the above error message with “(012) 997 2000” as test data for a Contact Number. 5.5.1 Explain the reason for this error message. (2) 5.5.2 The above error message is not totally user friendly. State TWO characteristics of a good error message. (2) Page 11 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 5.6 What is the difference between an array and an index? (2) 5.7 An array called arrMonths has been declared to contain the names of the months of the year. 5.7.1 A loop must be used to display the month names. Motivate whether a conditional or an unconditional loop should be used . (2) 5.7.2 A parallel array of integer type, called arrVisitors, has been declared. This array contains the number of people (as a number type) that visit the park each month. Why is it NOT possible to use a two-dimensional array instead of two separate parallel arrays to store this data? (1) 5.8 Permit numbers need to be generated for permit holders that visit the park for research purposes. Each permit number is made up of five digits and a control digit. The control digit is determined as follows: • The first five digits of the permit number are multiplied by descending numbers, starting at five. • Each of the answers is then added. • The control digit is the remainder after dividing the total by five. Example: Permit number: 43452 Control digit will be 1: (4*5 + 3*4 + 4*3 + 5*2 + 2*1 modulus 5 = 1) Six-digit permit number: 434521 • Write pseudocode to: o enter a five-digit number. o generate and add the control digit to the five-digit number. o display the six-digit permit number. (8) Totaal Section E: [25] Page 12 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 SECTION F: INTEGRATED SCENARIO QUESTION 6 With the national lockdown people spend a lot of their time online. 6.1 6.1.1 Name THREE items of personal information that should not be posted on a social networking site. (3) 6.1.2 What is identity theft? (2) 6.1.3 State TWO preventative measures that can be taken to avoid identity theft. (2) 6.1.4 What is a social engineer? (2) 6.1.5 Name TWO types of malicious software which someone could use to obtain your personal information without your knowledge. (2) 6.1.6 Cyber-bullying is becoming increasingly common. a) What is cyber-bullying? (1) b) Give an example of cyberbullying. (1) 6.2 Email communication between businesses and their clients is very important. 6.2.1 Distinguish between a web-based email and ISP-based email. (2) 6.2.2 A business wants to send out information regarding lockdown specials to the clients via email. Do they use the Cc or the Bcc option in the email? Motivate which one will be the best to use. (2) 6.3 Name THREE advantages of using apps as opposed to mobile web browsers from a business side. (3) 6.4 Explain the role af a virtual office in a company where all the workers have mobile offices. (2) 6.5 Briefly explain how one can trace a computer from which a message was transmitted. (1) Page 13 of 14 Please turn over
Downloaded INFORMATION from hlayiso.com TECHNOLOGY P2 GRADE 12 6.6 The Internet of things consists of web-enabled devices that collect, send and act on data they get from their surrounding environments. 6.6.1 State TWO examples of how clothing stores benefit from IoT. (2) 6.6.2 The diagram is an example of a smart diaper. Discuss ONE benefit of a smart diaper device. (1) 6.7 6.7.1 Explain the difference between virtual reality and augmented reality. (2) 6.7.2 Why is VR software a limitation to virtual reality? (1) 6.8 Some businesses allow clients to pay with digital currency like Bitcoin. 6.8.1 Online transactions are encrypted. Explain how encryption protects customers. (2) 6.8.2 Give TWO disadvantages of using Bitcoin for online payments. (2) 6.9 BitTorrent is a peer-to-peer protocol that is used to transfer large files over the internet. 6.9.1 Discuss TWO reasons why a person should not use BitTorrent software. (2) TOTAL SECTION F: [35] GRAND TOTAL: [150] Page 14 of 14

Study this subject

More from Grade 12 Information Technology

View all