9618_w22_qp_13
A paper of Computer Science, 9618
Questions:
10
Year:
2022
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
A digital audio message needs to be recorded. Tick () one box in each row to identify the effect of each action on the accuracy of the recording. Action Accuracy increases Accuracy decreases Accuracy does not change Change the sampling rate from 40 kHz to 60 kHz. Change the duration of the recording from 20 minutes to 40 minutes. Change the sampling resolution from 24 bits to 16 bits. The audio message is recorded with a sampling rate of 50 kHz and a sampling resolution of 16 bits. The recording is 20 minutes in length. Calculate the file size of the recording. Give your answer in megabytes and show your working. Working Answer megabytes A computer uses a buffer when playing the audio message. Explain the purpose of a buffer in a computer system using one other example.
1. Information representation  →  1.2. Multimedia Sound
3. Hardware  →  3.1. Computers and their components
Open
2
The relational database ASTRONOMY is used to store data about telescopes, the companies that own the telescopes and the photographs taken by the telescopes. The database has these three tables: COMPANY(TelephoneNumber, CompanyID, CompanyName) PHOTOGRAPH(PhotoID, TelescopeID, DateTaken, TimeTaken, Elevation) TELESCOPE(TelescopeID, CompanyID, SerialNumber) Complete the following table by writing the correct answer for each item. Item Answer a suitable field for the primary key in COMPANY a candidate key in TELESCOPE the degree of relationship between TELESCOPE and PHOTOGRAPH A Database Management System (DBMS) has several features. Identify the feature that describes the relationship between data and its structure. Complete the SQL script to return the total number of telescopes owned by the company whose ID begins with HW. SELECT ( ) FROM TELESCOPE WHERE LIKE ; Write the SQL script to add one field to the table PHOTOGRAPH to store the resolution of the photograph, e.g. 1920 × 1068. The photographs are stored as bitmap images. Complete the statements about bitmap images by writing the missing words. The of a bitmap image is the number of bits that are used to store each pixel. Metadata about the image is stored in the of the file. Describe the purpose of a query processor in a DBMS.
8. Databases  →  8.1. Database Concepts
8. Databases  →  8.2. Database Management Systems (DBMS)
Open
3
Draw one line from each Operating System (OS) management task to its most appropriate description. hardware management security management memory management process management OS Management task dynamically allocates memory to processes marks unallocated file storage for availability installs programs for devices connected to external ports allows processes to transfer data to and from each other validates user and process authenticity Description
16. System Software  →  16.1. Purposes of an Operating System (OS)
5. System Software  →  5.1. Operating Systems
Open
4
A Central Processing Unit (CPU) contains several special purpose registers and other components. State the roles of the following registers. Memory Address Register (MAR) Memory Data Register (MDR) State when interrupts are detected during the Fetch-Execute (F-E) cycle. A computer system contains a system clock. Describe the purpose of the system clock. Upgrading secondary storage to solid state typically improves the performance of computer systems. Identify one other upgrade to the hardware and explain why it improves the performance of a computer system. Upgrade Explanation
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open
6
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 LDX Indexed addressing. Form the address from + the contents of the index register. Copy the contents of this calculated address to ACC LDR #n Immediate addressing. Load the number n to IX MOV Moves the contents of the accumulator to the given register (STO Store contents of ACC at the given address ADD Add the contents of the given address to the ACC ADD #n Add the denary number n to the ACC SUB #n Subtract the denary number n from the ACC INC Add 1 to the contents of the register (ACC or JMP Jump to the given address CMP #n Compare the contents of ACC with number n CMI Indirect addressing. The address to be used is at the given address. Compare the contents of ACC with the contents of this second address JPE Following a compare instruction, jump to if the compare was True JPN Following a compare instruction, jump to if the compare was False OUT Output to the screen the character whose ASCII value is stored in ACC END Return control to the operating system can be an absolute or a symbolic address # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001101 The current contents of main memory and selected values from the ASCII character set are given. Trace the program currently in memory using the trace table. Address Instruction LDR #0 LDD 100 CMP #2 JPE 91 LDX 110 SUB #32 CMP #65 JPN 86 LDM #1 ADD 101 STO 101 LDM #1 ADD 100 STO 100 INC IX JMP 76 LDD 101 ADD #48 OUT END … … ASCII value Character A B C D Instruction address ACC IX Memory address Output Explain the purpose of relative addressing in an assembly language program. The following table shows another part of the instruction set for the processor. Instruction Explanation Opcode Operand AND #n Bitwise AND operation of the contents of ACC with the operand AND Bn Bitwise AND operation of the contents of ACC with the binary number n 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 Bn Bitwise OR operation of the contents of ACC with the binary number n 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 a symbolic address # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001101 The current contents of the ACC are: Show the contents of the ACC after the execution of the following instruction. AND B01001100 The current contents of the ACC are: Show the contents of the ACC after the execution of the following instruction. OR B01001111 The current contents of the ACC are: Show the contents of the ACC after the execution of the following instruction. LSR #2 One instruction group is data movement. Give the name of one other instruction group.
4. Processor Fundamentals  →  4.2. Assembly Language
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open
7
The diagram shows the hardware and software used to retrieve files stored on the cloud. Laptop Internet Service Provider A X B Firewall Complete the following table by writing the answer for each row. Answer The name of device A that allows the laptop to connect to the internet A type of cloud, X An example of an application, B, that can run on the cloud Give one advantage and two disadvantages of transmitting data using satellites instead of copper cables. Advantage 1 Disadvantage 1 Disadvantage 2 Local Area Networks (LANs) can be made up of several subnetworks. Give two benefits of dividing a network into subnetworks by subnetting the LAN. A subnet mask is used when subnetting a LAN. Two devices on the LAN are located in different subnetworks. The IP addresses and corresponding subnet masks are shown: Device IP address Subnet mask 10.10.12.1 255.0.0.0 192.168.12.4 255.255.255.0 Identify the following network ID and host ID. The network ID for the device with the IP address 10.10.12.1 The host ID for the device with the IP address 192.168.12.4
2. Communication  →  2.1. Networks including the internet
Open