9626_s20_qp_12
A paper of Information Technology, 9626
Questions:
14
Year:
2020
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
For each of the two tables below, tick the most accurate statement referring to symmetric encryption. ✓ Symmetric encryption is a newer method of encryption compared to asymmetric encryption With symmetric encryption the public key is used to encrypt the data With symmetric encryption you have to use the same key to encrypt every message Symmetric encryption only uses a single private key ✓ With symmetric encryption the private key must be kept private by both the sender and the receiver Symmetric encryption is often referred to as public key encryption It is possible to deduce the private key from the public key With symmetric encryption anyone with a copy of the public key can encrypt information
1. Data processing and information  →  1.3. Encryption
Open
2
Tick the most accurate statement regarding the use of word processing software for producing documents. ✓ It is easier to format paragraphs compared to database software It is easier to manipulate statistics compared to using spreadsheet software Word processing packages can be used to produce all multimedia features of a website Databases are more difficult to filter than word processed documents Tick the most accurate statement regarding the use of other software to manipulate data. ✓ It is easier to create a query using database software rather than using spreadsheet software It is easier to create a report using spreadsheet software rather than using database software It is harder to enter data and produce charts showing sales growth with a spreadsheet than using video editing software The easiest way to trim a sound sample is by using photo editing software Evaluate, by weighing up the advantages and disadvantages, the use of a web authoring package rather than a text editor to create a web page.
2. Hardware and software  →  2.3. Utility software
1. Data processing and information  →  1.5. Data processing
2. Hardware and software  →  2.4. Custom-written software and off-the-shelf software
Open
5
Many schools in the more remote areas of Kenya want to install video-conferencing equipment. This is so their students can be in touch with students from other Kenyan schools. Discuss the impact of video-conferencing on the more remote schools and their students, compared with having to visit the other schools to stay in touch. Several technologies can be used to deliver video-conferencing. Explain what is meant by the following terms. ADSL IEEE 802.11
14. Communications technology  →  14.5. Data transmission across networks
14. Communications technology  →  14.1. Networks
Open
7
Here is part of a database showing the earnings of a group of workers in a company. WorkerID Job_type Hours_worked Hourly_rate Weekly_pay Tyre changer €17.00 €22.00 €20.00 €18.00 €15.00 €15.00 €14.00 €14.00 €20.00 €18.00 €18.00 €714.00 €880.00 €760.00 €666.00 €585.00 €540.00 €532.00 €560.00 €740.00 €648.00 €684.00 Foreman Mechanic Painter Sander Sander Polisher Polisher Mechanic Painter Painter Describe, using an example from the database, the features of a calculated field. A number of fields in the database are not shown. Examples of these are first name and family name. In this database the WorkerID is a primary key. Explain why it is good practice to have a primary key in this database. Describe what a consistency validation check is and explain how it could be used in this database as a check when inputting data.
10. Database and file concepts  →  10.1. Creating a database
1. Data processing and information  →  1.4. Checking the accuracy of data
Open