9608_w21_qp_12
A paper of Computer Science, 9608
Questions:
10
Year:
2021
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
A computer has Random Access Memory (RAM) and Read Only Memory (ROM). Tick (✓) one or more boxes in each row to identify whether each statement refers to RAM, ROM or both. Statement RAM ROM Stores data permanently It is volatile Stores the start-up instructions for the computer Directly accessed by the CPU Type of main memory Stores currently running applications Can be static or dynamic
1. Theory Fundamentals  →  1.3. Hardware
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
2
A travel company is designing a website. The bitmap logo for the travel company is shown. Each colour is represented by a letter, for example, R = red, B = black, W = white. Bitmap Logo R R R R R R R R R B B B B B W R R B W W W B W R R B W W W W W R R B W W B B W R R B W W W B W R R B B B B B W R R R R R R R R R State the minimum number of bits needed to represent each pixel in the bitmap logo. Calculate the minimum file size, in bytes, of the bitmap logo. Show your working. Working File size The travel company uploads a video to its website. The video is stored as an MP4 file. MP4 is an example of a multimedia container format. Describe what is meant by a multimedia container format. Complete the following sentences that describe two terms related to videos. is when a sequence of consecutive pixels in the same frame have the same value. is when a pixel in the same location in two consecutive frames has the same value.
1. Theory Fundamentals  →  1.1. Information representation
Open
3
Upali travels for his work and uses his mobile phone to access the World Wide Web (WWW) and to communicate with his office by email. His office has a fixed connection to the Internet. Identify two types of communication systems that support the transmission of his data. Upali connects his computer to the Local Area Network (LAN) when he is in the office. The network uses both copper cables and fibre optic cables. Identify two other examples of network hardware that can be used in a LAN. Checksum is one method used for verification of transmitted data within a network. Name and describe one other method of verifying transmitted data. Method Description Upali works for a company that stores data on a web server. Describe two security measures that can be used to protect a web server from unauthorised access.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
3. Advanced Theory  →  3.2. Communication and Internet technologies
Open
4
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 Op Code Operand LDD Direct addressing. Load the contents of the location at the given address to ACC CMP Compare the contents of ACC with the contents of SUB Subtract the contents of the given address from the ACC INC Add 1 to the contents of the register (ACC or DEC Subtract 1 from the contents of the register (ACC or STO Store contents of ACC at the given address END Return control to the operating system The instructions in the processor’s instruction set can be grouped according to their function. Identify three different instruction groups from the instructions given in the table. Identify one instruction group not given in the table. The following are four special purpose registers used in the processor: • Program Counter (PC) • Memory Data Register (MDR) • Memory Address Register (MAR) • Current Instruction Register (CIR) Describe the purpose of any three registers from the four given. Register 1 Description Register 2 Description Register 3 Description
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
Jackie is writing a program in a high-level language (HLL). The program makes use of Dynamic Link Library (DLL) files. Complete the following sentences about DLL files by writing the missing words from the list given below. closed corrupted directory edited errors executable opened recompile running tested validated verified The file does not contain the library routines. A DLL file can be without having to the calling program. One drawback of a DLL file is that the main program could stop working if the DLL file is . Jackie will use language translation software to run her HLL program. Identify and describe one type of language translator. Translator Description Explain the reasons why Jackie should copyright her program.
1. Theory Fundamentals  →  1.5. System software
2. Fundamental Problem-solving and Programming Skills  →  2.4. Software development
Open
8
An employment agency keeps records of its contracts with employers and workers in a relational database. These are some of the tables in the database: EMPLOYER(EmpId, EmpName, EmpAddress, EmpPhoneNumber) WORKER(WkId, WkFirstName, WkLastName, WkAddress, WkPhoneNumber) CONTRACT_TYPE(ConTypeId, ConName) CONTRACT(ConId, ConTypeId, EmpId, WkId, RefConNumber) Complete the entity-relationship (E-R) diagram for this part of the database. EMPLOYER WORKER CONTRACT CONTRACT_TYPE Write a Data Definition Language (DDL) statement to change the CONTRACT table to remove the attribute RefConNumber. The following table has examples of DDL and Data Manipulation Language (DML) statements. Tick (✓) one box in each row to identify whether each statement is an example of DML or DDL. Statement DML DDL ADD PRIMARY KEY ALTER TABLE SELECT FROM INNER JOIN CREATE DATABASE The field WkPhoneNumber cannot be empty and must have a maximum of 14 characters. Describe two ways the field WkPhoneNumber can be validated. State what is meant by a candidate key. Describe what is meant by a secondary key. The database is stored on a magnetic hard disk. Describe the basic internal layout and operation of a magnetic hard disk drive.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open