9626_w20_qp_13
A paper of Information Technology, 9626
Questions:
12
Year:
2020
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
Tick the most accurate statement regarding input devices. ü A touch screen is easier to use than a keyboard for inputting large amounts of text Using a keyboard is the most efficient method of moving a file from one folder to another A scanner is an input device used for inputting hard copy documents A motor is an input device used for inputting physical variables in a control system Tick the most accurate statement regarding output devices. ü A sensor is an output device used as an actuator in a control system A dot matrix printer is the quickest printer for outputting large amounts of text A webcam is an output device used to display moving images An inkjet printer can be used to output high-quality photographs Hard disk drives, magnetic tape drives and solid-state drives (SSD) are often referred to as secondary storage devices whereas RAM and ROM are often referred to as primary storage devices. Explain why computers need secondary storage devices.
16. System life cycle  →  16.3. Design
2. Hardware and software  →  2.3. Utility software
2. Hardware and software  →  2.1. Mainframe computers and supercomputers
Open
2
Tick the statement which most accurately refers to the results of using utility software. ü Lossless compression reduces the number of bits by increasing redundant data Some information is lost in lossless compression Lossy compression reduces the number of bits by identifying unnecessary information and removing it Disk defragmentation organises the contents of the disk into the largest number of contiguous regions Tick the statement which most accurately refers to the properties of a hard disk. ü Data access is faster on a hard disk with fragmented files than on a defragmented hard disk Disk formatting prepares a data storage device for initial use The first stage of formatting is high-level formatting followed by low-level formatting Disk partitioning makes the data storage device invisible to an operating system A type of utility software enables files to be deleted. Explain how the delete utility works and how files can be recovered even after they appear to have been deleted.
2. Hardware and software  →  2.3. Utility software
16. System life cycle  →  16.3. Design
Open
10
Below are tables from a university database of Metallurgy students. Relationships link the tables. Students Studentid Phone Second_name A5384 Bhatti A6528 Schmidt B7238 Jones A8946 Gonzales D9476 Jones Courses Studentid Subject Teacher_code A5384 Geology of metals SMI A6528 Electrochemical Metallurgy LOU B7238 Geology of metals RIC A6528 Metallography SAN D9476 Physical Metallurgy SAN Teachers Teacher_code Subject 1 Subject 2 LOU Electrochemical Metallurgy Metallography RIC Geology of metals Crystallography SAN Metallography Physical Metallurgy SMI Electrochemical Metallurgy Geology of metals TUR Crystallography Geology of metals Define, exactly, each of the following terms giving examples of the only suitable fields for each, using the tables provided. Primary key Foreign key Compound key Explain, indicating the type of relationship formed, how the relationships were created connecting these tables. You can assume the tables were already populated with data. Describe, in detail, the two validation checks that could be carried out on the Studentid field which could not be carried out on the Second_name field.
10. Database and file concepts  →  10.1. Creating a database
Open
11
Amir has created a student database query which allows users to type in any name they choose and then the query finds everybody in the database with that name. Annisa has told him that this is a dynamic parameter query. Evaluate, by weighing up the advantages and disadvantages, dynamic parameter queries compared with static parameter queries. Please turn over for Question 12.
10. Database and file concepts  →  10.1. Creating a database
14. Communications technology  →  14.6. Network protocols
Open