9608_s19_qp_13
A paper of Computer Science, 9608
Questions:
5
Year:
2019
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
A computer has an operating system (OS) and utility software. The following table lists key management tasks performed by an operating system and their descriptions. Complete the table by writing the missing management task names and descriptions. Management task Description Memory management Provides user accounts and passwords Handles the signals sent when the attention of the processor is required elsewhere Provision of a software platform A hard disk formatter and a hard disk defragmenter are two examples of utility software. Describe the actions performed by a hard disk formatter and a hard disk defragmenter. Hard disk formatter Hard disk defragmenter Identify three other examples of utility software that can be installed on the computer.
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
Open
2
Frankie is a software developer. He is developing a program to manage customer records for a client with an online retail business. He must ensure that data stored about each customer are both secure and private. State the difference between security and privacy. Computer systems can be protected by physical methods such as locks. Describe two non-physical methods used to improve the security of computer systems. A computer uses parity blocks to check the data that has been received is the same as the data that has been transmitted. The following is an example of a parity block. Parity bit Data Parity byte Describe how a parity block check can identify a bit that has been corrupted during transmission. Give a situation where a parity block check cannot identify corrupted bits. One principle of the ACM/IEEE Software Engineering Code of Ethics is to always act in the best interest of the client. Explain how Frankie can ensure that he is acting in the best interest of his client. When the program is complete, Frankie uses a compiler to prepare the program for the client. Explain why Frankie uses a compiler instead of an interpreter.
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
Open
3
A company uses a relational database, EMPLOYEES, to store data about its employees and departments. The company uses a Database Management System (DBMS). The DBMS has a data dictionary. Describe what the data dictionary stores. The DBMS has a query processor. Describe the purpose of a query processor. Relationships are created between tables using primary and foreign keys. Describe the role of a primary and a foreign key in database relationships. In the company: • An employee can be a manager. • A department can have several managers and several employees. • An employee can only belong to one department. The EMPLOYEES database has three tables: EMPLOYEE_DATA( EmployeeID, FirstName, LastName, DateOfBirth, Gender, DepartmentNumber) DEPARTMENT(DepartmentNumber, DepartmentName) DEPARTMENT_MANAGER(DepartmentNumber, EmployeeID, role) Complete the entity-relationship (E-R) diagram for the EMPLOYEES database. EMPLOYEE_DATA DEPARTMENT DEPARTMENT_MANAGER Give three reasons why the EMPLOYEES database is fully normalised. Part of the EMPLOYEE_DATA table is shown. EmployeeID FirstName LastName DateOfBirth Gender DepartmentNumber 156FJEK Harvey Kim 12/05/1984 Male S1 558RRKL Catriona Moore 03/03/1978 Female F2 388LMDV Oscar Ciao 01/01/1987 Male F2 Write a Data Definition Language (DDL) statement to create the EMPLOYEES database. Write a DDL statement to define the table EMPLOYEE_DATA, and declare EmployeeID as the primary key. Write a Data Manipulation Language (DML) statement to return the first name and last name of all female employees in the department named Finance.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
4
A program is written in assembly language. The op codes LDM and LDD are used to load a register. The op code LDM uses immediate addressing, and the op code LDD uses direct addressing. Describe what happens when the following instructions are run. LDM #300 LDD 300 Assembly language instructions can be grouped by their purpose. The following table shows four assembly language instructions. Tick (✓) one box in each row to indicate the group each instruction belongs to. Instruction Description Jump instruction Arithmetic operation Data movement LDR #3 Load the number 3 to the Index Register ADD #2 Add 2 to the Accumulator JPN 22 Move to the instruction at address 22 DEC ACC Subtract 1 from the Accumulator The processor handles interrupts within the fetch-execute cycle. Give one example of a hardware interrupt and one example of a software interrupt. Hardware Software Explain how the processor handles an interrupt.
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
Xander creates a presentation that includes images, video and sound. The images are bitmap images. A bitmap image can be made up of any number of colours. Each colour is represented by a unique binary number. Draw one line from each box on the left, to the correct box on the right to identify the minimum number of bits needed to store each maximum number of colours. Maximum number of colours Minimum number of bits One of the videos has a frame rate of 40 fps (frames per second). State what is meant by 40 fps. One video uses interlaced encoding, and a second video uses progressive encoding. Describe two differences between interlaced and progressive encoding. The sound track has a sampling rate of 88.2 kHz and a sampling resolution of 32 bits. State what is meant by a sampling rate of 88.2 kHz and a sampling resolution of 32 bits. Sampling rate of 88.2 kHz Sampling resolution of 32 bits
1. Theory Fundamentals  →  1.1. Information representation
Open