9618_s22_qp_12
A paper of Computer Science, 9618
Questions:
9
Year:
2022
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Draw one line from each image representation term to its correct definition. Term Definition Pixel Bit depth Image resolution File header The number of pixels wide by the number of pixels high The smallest identifiable component of an image Stores data about the image file, e.g. file format, number of bits per pixel, file size The number of bits used to represent each colour The following section of a bitmap image is 10 pixels wide and 5 pixels high. In this example, each colour is represented by a letter, e.g. B is blue. B B B B B B B B B B Y Y P Y Y Y P Y Y Y R R M R P K T T R R B O P Y Y Y P G P P R O R P P P R R R R The complete image can have up to 256 colours. Identify the smallest number of bits that can be used to represent each colour in the complete bitmap image. Calculate an estimate for the file size of the section of the bitmap image shown, giving your answer in bytes. Use your answer from part . Show your working. Working Answer bytes Describe how changing the colour depth of an image affects its file size. The first row of pixels in the image from part is shown: B B B B B B B B B B Explain how this row of pixels can be compressed using lossless compression.
1. Information representation  →  1.2. Multimedia Graphics
Open
2
A car has several features. One feature is a lane detection system. This system monitors the lines on either side of the lane. If the car gets too close to one line, the system automatically moves the car away from the line. Explain why the lane detection system is an example of an embedded system. Two other features: • record the number of miles travelled in the current journey, from when the engine is turned on to when it is turned off • record the total number of miles the car has travelled since it was built. Identify the data that will be stored in the primary and secondary storage of the car for these two features. Primary Secondary The car has a resistive touchscreen for the user to select options. Tick (3) one box in each row to show whether each statement about a resistive touchscreen is true or false. Statement True False The screen always has five different layers A processor determines the horizontal and vertical coordinates of the point of contact The touchscreen will work if any object touches the screen
3. Hardware  →  3.1. Computers and their components
16. System Software  →  16.1. Purposes of an Operating System (OS)
Open
3
The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC). Instruction Explanation Opcode Operand AND #n Bitwise AND operation of the contents of ACC with the operand AND Bitwise AND operation of the contents of ACC with the contents of XOR #n Bitwise XOR operation of the contents of ACC with the operand XOR Bitwise XOR operation of the contents of ACC with the contents of OR #n Bitwise OR operation of the contents of ACC with the operand OR Bitwise OR operation of the contents of ACC with the contents of can be an absolute or a symbolic address # denotes a denary number, e.g. #123 The ACC currently contains the following positive binary integer: Write the bit manipulation instruction that would change the binary integer in ACC to: Opcode Operand The ACC currently contains the following positive binary integer: Write the bit manipulation instruction that would change the binary integer in ACC to: Opcode Operand Convert the following positive binary integer into hexadecimal. 0 1 1 1 1 1 1 0 A three-place logical shift to the left is performed on the following positive binary integer. Show the result of this logical shift. 0 1 1 1 1 1 1 0 Convert the denary numbers 127 and 12 to 8-bit binary and then perform the subtraction 12 − 127 in binary. Show your working. 127 in binary 12 in binary 12 − 127 in binary
1. Information representation  →  1.1. Data Representation
4. Processor Fundamentals  →  4.3. Bit manipulation
Open
4
A school stores personal data about its staff and students on its computer system. Explain why the school needs to keep both its data and its computer system secure from unauthorised access. Data Computer system Complete the table by identifying two security threats to the data on a computer. Describe each threat. Give a different prevention method for each threat. Threat Description Prevention method Data is encrypted when it is transmitted within the school network, or externally such as over the internet. Describe what is meant by encryption and explain why it is used.
6. Security, privacy and data integrity  →  6.1. Data Security
Open
5
A database, FILMS, stores information about films and actors. Part of the database is shown: ACTOR(ActorID, FirstName, LastName, DateOfBirth) FILM_FACT(FilmID, FilmTitle, ReleaseDate, Category) FILM_ACTOR(ActorID, FilmID) Complete the entity-relationship (E-R) diagram. ACTOR FILM_FACT FILM_ACTOR A composite primary key consists of two or more attributes that together form the primary key. Explain why the table FILM_ACTOR has a composite primary key. Complete the SQL script to return the IDs of all the actors in the film with the title Cinderella. SELECT FROM FILM_ACTOR INNER JOIN ON FILM_FACT.FilmID = WHERE FILM_FACT.FilmTitle = ; Write an SQL script to count the number of films that were released in January 2022. A Database Management System (DBMS) is used to create and manipulate the database. Complete the descriptions of the features and tools found in a DBMS using the given terms. Not all terms will be used. Boolean data dictionary data redundancy field names input interface logical schema normalisation operating system output primary keys query structure A DBMS provides data management. This includes the development of a that stores information about the data stored, such as and . The uses methods, such as an E-R diagram, to show the structure of the database and its relationships. The processor allows a user to perform searches to find specific data. The DBMS also provides a developer that allows the user to create tables, forms and reports.
8. Databases  →  8.1. Database Concepts
8. Databases  →  8.2. Database Management Systems (DBMS)
Open
9
The following incomplete table contains four network devices and their descriptions. Complete the table by writing the missing devices and missing descriptions. Device Description Receives and sends data between two networks operating on the same protocol Wireless Network Interface Card (WNIC) Restores the digital signal so it can be transmitted over greater distances Wireless Access Point (WAP) Describe three differences between fibre-optic cables and copper cables. Ethernet uses Carrier Sense Multiple Access/Collision Detection (CSMA/CD). Describe CSMA/CD.
2. Communication  →  2.1. Networks including the internet
Open