9608_w19_qp_11
A paper of Computer Science, 9608
Questions:
5
Year:
2019
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Von Neumann is an example of a computer architecture. The diagram has registers used in Von Neumann architecture on the left and descriptions on the right. Draw one line to match each register with its correct description. Register Description Current Instruction Register Memory Address Register Program Counter Memory Data Register Stores the address of the memory location about to be written to or read from Stores the address of the next instruction to be read Stores the address of the input device from which the processor accesses the instruction Stores the instruction that is being decoded and executed Stores the data that has just been read from memory, or is about to be written to memory Many components of the computer system transfer data between them using buses. One example of a bus is an address bus. Name two other buses that exist within a computer and give the purpose of each. Bus 1 Purpose Bus 2 Purpose State the benefit of increasing the address bus width from 16 bits to 32 bits. The following statements describe features of a low-level language. Complete the statements by writing the appropriate terms in the spaces. A is a sequence of instructions that are given an identifier. These instructions may need to be executed several times. A is an instruction that tells the assembler to do something. It is not a program instruction. The processor’s instruction set can be put into several groups. One of these groups is .
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
2
Aaron uses a desktop computer to do school work. Aaron has a mouse and keyboard that he can use as input devices and a monitor as an output device. Identify two additional input devices Aaron could use with his desktop computer. Identify two additional output devices Aaron could use with his desktop computer. Aaron needs to store a large number of applications and data on his computer. He needs at least 50GB of secondary storage space. Identify one internal secondary storage device for Aaron’s computer. Describe the internal operation of a trackerball mouse. Aaron’s computer has an operating system (OS). The OS manages the running processes and provides a user interface. Describe these OS management tasks. Process management Provision of a user interface Aaron’s computer has a virus checker and backup software. Describe these utility programs. Virus checker Backup software Aaron creates a web page using JavaScript code and HTML tags. Describe how the JavaScript code is translated using an interpreter.
3. Advanced Theory  →  3.4. System software
1. Theory Fundamentals  →  1.5. System software
Open
3
A bank approves a customer for an account based on the criteria in the following table. Parameter Description of parameter Binary value Condition A Employed True False B Self-employed True False C Over 21 True False D Earn more than 30 000 True False E Another account True False A customer is approved (X = 1) if the person: • is over 21 and employed or • is over 21 and self-employed and • either earns more than 30 000 or • has another account. Draw a logic circuit to represent the model. A B X D E C Complete the truth table for the logic expression: X = (A AND C) OR (NOT A AND (B XOR C)) A B C Working space X
1. Theory Fundamentals  →  1.3. Hardware
3. Advanced Theory  →  3.3. Hardware
Open
4
Customers of a bank can access their account information by logging in on the bank’s website. The bank has a client-server model of networked computers. Describe, using the bank as an example, the key features of a client-server model. Give two other examples of applications that can use the client-server model. The bank’s customers log in to the website using a web application. Explain why the web application uses server-side scripting. The bank is upgrading its local area network (LAN) copper cables to fibre-optic cables. State two benefits to the bank of upgrading to fibre-optic cable from copper cable. State two drawbacks of upgrading to fibre-optic cables. The bank uses a relational database, ACCOUNTS, to store the information about customers and their accounts. The database stores the customer’s first name, last name and date of birth. The bank has several different types of account. Each account type has a unique ID number, name (for example, regular or saving) and bonus (for example, $5.00, $10.00 or $15.00). A customer can have more than one account. Each customer’s account has its own ID number and stores the amount of money the customer has in that account. The bank creates a normalised, relational database to store the required information. There are three tables: • CUSTOMER • ACCOUNT_TYPE • CUSTOMER_ACCOUNT Write the attributes for each table to complete the database design for the bank. CUSTOMER( ) ACCOUNT_TYPE( ) CUSTOMER_ACCOUNT( ) Identify the primary key for each table that you designed in part . CUSTOMER ACCOUNT_TYPE CUSTOMER_ACCOUNT Identify one foreign key in one of the tables that you designed in part . Table name Foreign key The following table has definitions of database terms. Write the correct database term in the table for each definition. Definition Term All the data about one entity The data in one row of a table A column or field in a table
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
5
The bit depth of an image dictates how many different colours can be represented by each pixel. State the number of different colours that can be represented by a bit depth of 8 bits. One binary colour is represented by 0100 1110 Convert the unsigned binary number 0100 1110 into denary. Convert the denary number −194 into 12-bit two’s complement. Convert the Binary Coded Decimal (BCD) value 0110 1001 into denary. Identify one practical application where BCD is used. One example of a character set used by computers is ASCII. Describe how one character is represented in a character set. Data can be compressed using either lossy or lossless compression. Tick (✓) one box in each scenario to identify whether lossy or lossless compression should be used. Justify your choice. A program written in a high-level language. Lossy Lossless Justification A photograph that needs to be emailed to a friend. Lossy Lossless Justification You need to upload a video that you have created to a website. Lossy Lossless Justification
1. Theory Fundamentals  →  1.1. Information representation
Open