9618_w21_qp_11
A paper of Computer Science, 9618
Questions:
8
Year:
2021
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Draw one line from each binary value to its equivalent value on the right. 1 kibibyte 1 gigabyte 1 byte 1 kilobyte 1 gibibyte 1 megabyte 1 mebibyte 8 bits 8000 bits 1000 kilobytes 1024 mebibytes 8192 bits Binary value Perform the following binary addition. Show your working. + 00110111 State how an overflow can occur when adding two binary integers. Convert the hexadecimal value F0 into denary.
1. Information representation  →  1.1. Data Representation
13. Data Representation  →  13.3. Floating-point numbers, representation and manipulation
Open
2
Xanthe wants to maintain the integrity and security of data stored on her computer. Explain the difference between data security and data integrity. Xanthe uses both data validation and data verification when entering data on her computer. Describe how data validation helps to protect the integrity of the data. Give an example in your answer. Description Example Describe how data verification helps to protect the integrity of the data. Give an example in your answer. Description Example Two malware threats are spyware and viruses. Give two similarities and one difference between spyware and a virus. Similarity 1 Similarity 2 Difference
6. Security, privacy and data integrity  →  6.1. Data Security
6. Security, privacy and data integrity  →  6.2. Data Integrity
Open
4
Francis is starting his first job as a software developer for a multinational company. Francis has been advised to join a professional ethical body. Describe the benefits to Francis of joining a professional ethical body. Francis is shown the software he will be working on. He is unfamiliar with the Integrated Development Environment (IDE) he is required to use. Describe the ways in which Francis can act ethically in this situation. A typical IDE provides debugging tools to support the testing of a program. Identify three other tools or features found in a typical IDE to support the writing of the program. Francis is part of a team writing a program. He finds an error in part of the program that has already been tested. He decides not to tell anyone because he is worried about the consequences. Explain the reasons why Francis acted unethically in this situation. Francis’s team use language translators. Complete the descriptions of language translators by writing the missing words. are usually used when a high‑level language program is complete. They translate all the code at the same time and then run the program. They produce files that can be run without the source code. translate one line of a high‑level language program at a time, and then run that line of code. They are most useful while developing the programs because errors can be corrected and then the program continues from that line. Assemblers are used to translate assembly code into .
7. Ethics and Ownership  →  7.1. Ethics and Ownership
5. System Software  →  5.2. Language Translators
Open
5
Javier owns many shops that sell cars. He employs several managers who are each in charge of one or more shops. He uses the relational database CARS to store the data about his business. Part of the database is shown: SHOP(ShopID, ManagerID, Address, Town, TelephoneNumber) MANAGER(ManagerID, FirstName, LastName, DateOfBirth, Wage) CAR(RegistrationNumber, Make, Model, NumberOfMiles, ShopID) Tick () one box in each row to identify whether each field is a primary key or a foreign key. Table Field name Primary key Foreign key MANAGER ManagerID SHOP ManagerID CAR RegistrationNumber CAR ShopID Describe the ways in which access rights can be used to protect the data in Javier’s database from unauthorised access. Javier uses Data Definition Language (DDL) and Data Manipulation Language (DML) statements in his database. Complete the following DML statements to return the number of cars for sale in each shop. SELECT COUNT( ) FROM ShopID Complete the DML statement to include the following car in the table CAR. Field Data RegistrationNumber 123AA Make Tiger Model Lioness NumberOfMiles ShopID 12BSTREET CAR ("123AA","Tiger","Lioness",10500,"12BSTREET")
8. Databases  →  8.3. Data Definition Language (DDL) and Data Manipulation Language (DML)
Open
6
There are two errors in the following register transfer notation for the fetch‑execute cycle. MAR [PC] PC [PC] − 1 MDR [MAR] CIR [MDR] Complete the following table by: • identifying the line number of each error • describing the error • writing the correct statement. Line number Description of the error Correct statement The following table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC), and an Index Register (. Instruction Explanation Opcode Operand LDM #n Immediate addressing. Load the number n to ACC LDD Direct addressing. Load the contents of the location at the given address to ACC STO Store the contents of ACC at the given address INC Add 1 to the contents of the register (ACC or CMP Compare the contents of ACC with the contents of JPN Following a compare instruction, jump to if the compare was False JMP Jump to the given address IN Key in a character and store its ASCII value in ACC OUT Output to the screen the character whose ASCII value is stored in ACC END Return control to the operating system 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 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 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 LSL #n Bits in ACC are shifted logically n places to the left. Zeros are introduced on the right hand end LSR #n Bits in ACC are shifted logically n places to the right. Zeros are introduced on the left hand end can be an absolute or symbolic address # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001101 The current contents of main memory are shown: Address Data
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
4. Processor Fundamentals  →  4.2. Assembly Language
Open
7
Bobby is recording a sound file for his school project. He repeats the recording of the sound several times, with a different sample rate each time. Describe the reasons why the sound is closer to the original when a higher sample rate is used. Describe the reasons why the sound file size increases when a higher sample rate is used. Bobby wants to email the sound file to his school email address. He compresses the file before sending the email. Explain the reasons why Bobby compresses the sound file. Bobby uses lossless compression. Describe how lossless compression can compress the sound file.
1. Information representation  →  1.3. Compression
1. Information representation  →  1.2. Multimedia Sound
Open
8
A school is setting up a network within one of its buildings. State whether the network will be a LAN (local area network) or a WAN (wide area network). Justify your choice. One classroom in the building has 30 computers. The computers need to be connected to the network. Each computer has a network interface card (NIC). Identify two possible devices that can be used to physically connect the 30 computers to the rest of the network. The school has several laptops. Each laptop has a Wireless Network Interface Card (WNIC). Describe the functions of a Wireless Network Interface Card.
2. Communication  →  2.1. Networks including the internet
Open