INFORMATION TECHNOLOGY
GRADE 12
PAPER 2
NSC PAST PAPERS AND MEMOS
SEPTEMBER 2017
SECTION A: SHORT QUESTIONS
QUESTION 1
1.1
1.1.1 HTTP ✔ (1)
1.1.2 Byte ✔ (1)
1.1.3 Rootkit ✔ (1)
1.1.4 Patch ✔ (1)
1.1.5 SPAM ✔ (1)
1.1.6 Thread ✔ (Accept multithreading) (1)
1.1.7 Topology ✔ (1)
1.1.8 Microblogging ✔ (Accept tweeting) (1)
1.1.9 4G/LTE ✔ (1)
1.1.10 Bandwidth ✔ (1)
1.2
1.2.1 D ✔ copy your own CD to play on your mp3 player. (1)
1.2.2 B ✔ a sequence of logical steps that will solve a problem. (1)
1.2.3 C ✔ text file that stores information relating to websites. (1)
1.2.4 D ✔ Digital signature (1)
1.2.5 B ✔ Wireless communication between PCs in a different rooms. (1)
TOTAL SECTION A: 15
SECTION B: SYSTEMS TECHNOLOGIES
QUESTION 2
2.1
2.1.1 Any ONE fact ✔
2.1.2
2.1.3
2.2
2.2.1 Universal Serial Bus ✔ (1)
2.2.2 Accept any ONE of the following: ✔
2.2.3
2.2.4 Standard driver: Any ONE correct fact ✔
2.2.5 Any ONE device that connects to USB port that can make use of standard/generic driver. ✔
Examples of devices:
2.3
2.3.1 Yes / No and a valid reason to justify their answer. ✔ (1)
2.3.2 Any TWO advantages:
Any TWO disadvantages:
2.4
2.4.1 Speed (GHz) ✔ and Cores ✔ (2)
2.4.2 Any TWO correct facts about preventing overheating ✔✔
[24]
QUESTION 3
3.1
3.1.1 Accept any ONE: ✔
3.1.2 Accept any TWO advantages of the connection mentioned in QUESTION 3.1.1 ✔✔
3G/LTE
ADSL
WiMAX
3.2
3.2.1 A router manages the bandwidth because it is able to inspect the data packets as they arrive and determine the correct destination ✔ of the data and forward it accordingly. ✔ (2)
3.2.2 Accept any TWO other capabilities of a router: ✔✔
3.3
3.3.1 Any ONE of the following: ✔
3.3.2 Any TWO of the following: ✔✔
3.4
3.4.1 A search engine works as an information locator. ✔ It uses keywords or phrases entered by the user when looking for information. (1)
3.4.2 It is a technology/strategy ✔ used to obtain a high ranking placement in the search results page of a search engine. ✔ (2)
3.4.3 Any THREE of: ✔✔✔
3.4.4 Any ONE explanation: ✔✔
3.5
3.5.1
3.5.2 Any TWO of: ✔✔
3.5.3 Server side scripting makes dynamic creation of webpages possible, ✔ whilst connecting easily to a database. ✔ (2)
3.5.4 Any ONE of: ✔
[25]
QUESTION 4
4.1
4.1.1 Any THREE of: ✔✔✔
4.1.2 A relational database that contains many tables linked together by relations. ✔ (1)
4.2
4.2.1 Any TWO of: ✔✔
4.2.2 Data maintenance involves keeping information up to date. ✔ (1)
4.3
4.3.1 Normalisation refers to the process of organising a database into separate tables in such a way as to avoid the duplication of data and also update/deletion anomalies. ✔ (1)
4.3.2 Markup or the Total Value fields ✔ as they can automatically be calculated when needed using a calculated field. ✔ (2)
4.3.3
Table Names ✔✔
Primary Keys ✔✔
Foreign Key ✔
Relationship ✔ (6)
4.4
4.4.1 SELECT * FROM Stock_DetailsTB ✔Order BY TotalValue ✔ (2)
4.4.2 DELETE ✔ From Stock_DetailsTB✔ WHERE Item=’Dress’ ✔ (3)
4.4.3 UPDATE Stock_DetailsTB ✔ SET Contact = '0715624117' ✔ WHERE Owner's Name = 'Malcolm Peter'✔ (3)
[24]
QUESTION 5
5.1
Get the name and surname ✔
Initialise a blank string ✔
Get the length of name and surname ✔
Loop through the entire string ✔
If the character is not a vowel or a space then add to the blank string ✔
Change the first and last character to a capital letter ✔
Add a # to the end ✔ (7)
5.2
5.2.1 Indicates that the attributes are private fields ✔ (1)
5.2.2 Accessor methods are used to return the contents of an object's fields ✔ e.g. GetTeamName, ✔GetGender, GetDOB,
Mutator methods are used to change the contents of an object's fields ✔ e.g. CalculateCost ✔ (4)
5.2.3 A constructor instantiates the object ✔and initialises the fields of the object. ✔ (2)
5.2.4 Compiles the objects attributes into a single string variable ✔ (1)
5.3
One mark per correct column. (6)
[21]
SECTION F: INTEGRATED SCENARIO
QUESTION 6
6.1
6.1.1 RFID tag ✔
RFID reader ✔
6.1.2
6.1.3 RFID tags would not be advisable ✔ since it is a stall and people do not have a designated entry or exit point to check for the tags. ✔ (2)
6.2
6.2.1 Any TWO of: ✔✔
6.2.2
6.2.3 Social engineering refers to ‘conning’ or tricking a person into giving out information willingly. ✔ This often includes sensitive information such as passwords or other information that can be used to commit identity theft. ✔ (2)
6.2.4 Whatever you publish is immediately public and ‘vulnerable’ in terms of being shared. ✔
ACCEPT ALSO:
Multiple people have access to that information – especially if the group does not have a controlled or limited membership. (1)
6.3
6.3.1 Distributed Denial of Service in an attack that make a website unavailable ✔ by the use of thousands or millions of computers to request data from the site at the same time. The servers become overloaded, unresponsive and effectively unavailable to everyone. ✔ (2)
6.3.2 A botnet is a remotely controlled zombie PC infected with malware ✔ that enables criminals to use it for launching DOS attacks, or sending spam. ✔ (2)
6.3.3 Trolling is sowing discord on the Internet by starting arguments or upsetting people, by posting inflammatory, extraneous, or off topic messages in an online community (such as a newsgroup, forum, chat room, or blog) with the deliberate intent of provoking the readers. ✔
Therefore, one cannot cause a DOS by doing this. ✔ (2)
6.3.4 ONE of: ✔
6.4
6.4.1 Secure Socket Layer ✔ (1)
6.4.2 Encryption is when clear and easy to read data is scrambled to protect it and make it unreadable. ✔ (1)
6.4.3
6.5
6.5.1 The use of resources offered as services over the Internet ✔ and shared between many users, including online file storage services and the running of programs. ✔ (2)
6.5.2 Online file Storage – Storing files on the internet, which can be accessed from multiple devices and shared with others ✔
Examples: Any ONE ✔
Online Backup – Used to backup data that you only access when disaster strikes, which may include your system settings. ✔
Examples: Any ONE✔
6.5.3 DISAGREE ✔
6.5.4 There is an application installed on the device ✔that runs to create the user interface and so reduce the amount of data that needs to be transferred. ✔ (2)
[41]
TOTAL SECTION F: 41
GRAND TOTAL: 150