This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1โ Section header โ
1.1Various options are provided as possible answers to the following questions. Write down the question number (1.1.1
1.1\, choos e the answer and make a cross (X\ over the letter (A D\ of your choice in the ANSWER BOOK. EXAMPLE:
1.1The result of the expression (1\
1.1A digital signature is when someone signs an electronic document. to identify the sender of an electronic message as the default signature that is added to an e mail address.
1.1
1.1.4
1.1.5To establish a relationship between two tables in a database, a link must be made from the ublic key to private key oreign key to private key rimary key to public key rimary key to foreign key
1.2Give ONE word/term for each of the following descriptions. Write only the word/term next to the question number (1.2.1
1.2.10\ in the ANSWER BOOK.
1.2.1The amount of data an ISP allows a user to upload and download in a particular time period (1\
1.2.2A website that is regularly updated with news and events in chronological order (1\
1.2.3A person who breaks into a system to steal data electronically make unauthorised changes to electronic data (1\
1.2.4An Internet service that translates domain name to an IP address e.g. www.abcd.com translates to 169.
0.1(1\
1.2.5The protocol used for secure encrypted transfer of data the Interne (1\
1.2.6The process whereby the existing firmware wiped and replaced an updated version (1\
1.2.7An Internet based alternative to text messaging, in which multimedia can be exchanged in real time via applications such as WhatsApp (1\
1.2.8common format for storing digital music by combining efficient compression techniques and good sound quality (1\
1.2.9Gaining unauthorised ccess to and making use of a connection in an unsecured Wi Fi network (1\
1.2.10Start up test performed to ensure that all essential hardware is present and in working order (1\ TOTAL SECTION A:
Q2โ Section header โ
2.1choice h as to be made between purchasing fat thin client computers. Motivate the use of thin client computers for the office (2\
2.3.1What term is used to describe the technique where more than one CPU core works on separate applicati
2.3.2Caching is used in a variety of situations in a computer system. (a\ What is the main aim of caching, irrespective of where it occurs? (2\ (b\ Explain how disk caching improves the performance
2.3Except for caching , name ONE other factor that can improve the performance of computer system AND expla n how it will improve performance (2\
2.4State the common task that is executed by both an interpreter and a compiler. (2\ Upgrading computer hardware and software can be considered as an alternative to replacing computers Suggest TWO
2.6There are many economic onsiderations when using the computers in the travel agency.
2.6.1Besides switching off all computers at night, state TWO other ways in which the electricity usage of computing devices can be decreased. (2\
2.6.2Explain TWO ways in which th e use of computers will be financially beneficial for the travel agency (2\ incorrect statement was made that the use of an effective
2.7.1Describe TWO as pects of an effective backup maintenance program. (2\
2.7.2Define the term disk fragmentation (1\
2.8solid state drive (SSD\ is used for storage in some devices. Give TWO reasons why SSDs
Q3โ Section header โ
3.1.3Suggest a suitable topology for the LAN. (1\
3.2The travel agency uses a client server network. State TWO advantages o f using a client server network rather than a peer network. (2\
3.3The system administrator or the travel agency will make sure that software is regularly updated.
3.3.1Suggest ONE reason for keeping software up to date. (1\
3.3State TWO other responsibilities of the system administrator. (2\ Security of client data is essenti al in the travel industry . Malware can attack a computer through the network. Explain what role password protection
3.4Define the term malware
3.4Explain ow a firewall assists in providing security to computers on a network. LAN Device A
3.5Explain what a dynamic web page is. (2\ How are CSS (cascading style sheet used in developing a
3.5digital certificate is attached to t he company s website. (a\ Why is it recommended tha t the company
Q4โ Section header โ
4.1Which ONE of the following is an example of a DBMS? Oracle MS Excel FireFox Delphi (1\
4.2Name TWO aspects of database design that should be addressed o ensure effective functionality. (2\
4.3Explain what a record in a datab is.
4.3.2All the data types have been set to text. Identify ONE field where the data type needs to change AND suggest a more suit
4.3The design of the tblTours table allows a nomalies occur. (a\ Explain what an update anomaly
4.3.4The following SQL statement is executed: What is the result after executing this statement? (2\ 10 SC
4.5The data in the database can be used for data mining. Explain what data mining (2\
4.6SQL queries are used to obtain information from the database. plain how SQL injection can be used as a hacking tool. (2\
4.7The travel agency uses a distributed database. Give TWO reasons why distributed database s are used (2\
4.7Name the TWO models for distributed databases that are sed to ensure that data on various servers remain
Q5โ Section header โ
5.1The travel agency uses t he interface below as a booking form for holiday accommodation. The different types of available accommodation can be
5.1.1(a\ Numbers 1 3 indicate that edit boxes are used for data input. In each case (numbers 1 3\ indicate a more ap propriate input component to ensure that
5.1.2The data entered using the changed form must be validated and verified. (a\ Explain the following concepts: (i\ Valid data
5.1.1will ensure that valid data is entered. 12 SC
5.2The two dimensional array arrVisitors represented in the table below, stores the number of visitors to a fun park and an animal park.
5.2.1QUESTION
5.2.2Load values into the arrVisitors array for the first two columns [counter1,counter2] End inner loop End outer loop The given algorithm is missing a statement that causes a
5.2.1Explain what is meant by a logical error (2\
5.2To solve he logical error, t he total number of visitors for each month must be stored in the 2D array, using the following statement: arrVisitors[ x , y ] total (a\ Replace and
5.2Indicate the changes that need to be made in lines 2 to 5 of the given algorithm if the sum of the columns must be determined
5.2.4Two values in the array ha been captured incorrectly. The values for Fun park and Animal park for May
5.3The incomplete UML diagram below epresent a Boo king class in OOP Booking accommodationType numAdults numChildren
5.3.1What does the abbreviation refer to? (1\
5.3.2What is the purpose of a constructor method in a class? (1\
5.3.3Motivate why it is NOT necessary to have the field numberOfDays as an attribute of the class. (1\
5.3.4What is the implication of declaring the method calcDays(\ as a private method? (1\
5.3.5The starting date of the booking has been initialised in the constructor. Explain why a setStartDate(\ metho d may still be required?
5.3.6Explain the purpose of a toString(\ method. (2\ TOTAL SECTION 14
Q6โ Section header โ
6.1.1Except for mak ing calls and accessing the network, state ONE way in which a smartphone can be useful as a business tool. (1\
6.1.2Discuss TWO disadvantages of doing business using a smartphone. (2\ Which online service is used to ensure that tra vel agents will have access to
6.2There is a need for access control at the travel agent office building State TWO methods that the agency can use to control access to the building
6.3The travel agency s AUP prohibits the use of social networking sites on the agency s computers.
6.3.1Write out the a bbreviation AUP in full. (1\
6.3.2Except for the example already given, n ame TWO her aspects that should be included in the travel agency s AUP (2\
6.3.3Motivate TWO reasons why the prohibition of social networking sites at work is justified (2\ The agents will also need access to the company intranet hat is an
6.4Suggest way in which the travel agents could gain access to the travel agency intranet securely when working on their tablet computer from home (1\
6.5An Ethernet connection with MAC address refers to the NIC of a computer at the office.
6.5.1What is the funct ion of a NIC? (1\
6.5.2What is the purpose of MAC address? (1\ 15 SC
6.8Customers will be able to book and pay online using the digital currency BitCoin
6.8.1Online transactions are encrypted. Explain the term encryption (2\
6.8.2Online security methods include the use of public key encryption. Briefly xplain the public key encryption method (2\
6.8.3State ONE disadvantag e of using BitCoin to pay onlin (1\ BitTorrent software is blocked on the network in the office. What is BitTorrent State TWO bene fits of using BitTorrent.
6.10Downloading software may sometimes be considered as software piracy. Give TWO examples when download ing software will not be regarded as piracy