9608_w21_qp_11
A paper of Computer Science, 9608
Questions:
11
Year:
2021
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
An image can be either a bitmap image or a vector graphic. Vector graphics are made up of drawing objects and their properties. State what is meant by a drawing object. Identify four properties of a drawing object. Identify three items that are stored in a bitmap file header. A bitmap image needs to be compressed before it can be sent by email. Describe one lossy and one lossless method of compressing the image. Lossy Lossless
1. Theory Fundamentals  →  1.1. Information representation
Open
3
Server-side scripting is used to access a company database over the Internet. Steps 1 to 6 describe the sequence of events. Four of the statements A, B, C, D, E and F are used to complete the sequence. Letter Statement A The web server processes the PHP code. B The server renders the HTML code and displays the web page. C The browser renders the HTML code and displays the web page. D The web server returns the (HTML) web page to the client web browser. E The web server accesses the page from its hard disk. F The web browser processes the PHP code. Write one of the letters A to F in each appropriate row to complete the sequence. 1. The browser requests the web page from the web server. 2. 3. 4. The web server produces the HTML code for the web page. 5. 6.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
4
Oliver needs to increase the secondary storage on his computer. He already has several hard disks. Identify two other secondary storage devices that Oliver could use. Each device must be different. Oliver needs a scanner to make digital copies of some paper documents. Describe the basic internal operation of a scanner. Oliver wants to upgrade the RAM in his computer. He is not sure whether his computer has Static RAM (SRAM) or Dynamic RAM (DRAM). Draw one or more lines from each type of RAM to its appropriate description. Type of RAM Description SRAM DRAM Is less expensive to manufacture Needs to be refreshed Has more complex circuitry Is often used as cache Has faster access time
1. Theory Fundamentals  →  1.3. Hardware
Open
6
Complete the following sentences that describe parts of a processor in a Von Neumann model for a computer system. There are buses that transfer data between components in a computer system. The width of the determines the number of directly accessible memory locations. The sends signals on the to direct the operation of system components. pulses are used to synchronise the components on the motherboard. Describe the stages of the fetch-execute (F-E) cycle.
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
7
A computer has an operating system (OS). State three memory management tasks performed by the OS. State two input/output device management tasks performed by the OS. Utility programs are also provided with the OS. Identify and describe two different utility programs. Utility program Description Utility program Description Some operating systems include library programs. State three benefits to a programmer of using library programs.
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
Open
8
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 the ACC LDI Indirect addressing. The address to be used is at the given address. Load the contents of this second address to the ACC STO Store the contents of the ACC at the given address ADD Add the contents of the given address to the ACC INC Add 1 to the contents of the register (ACC or JMP Jump to the given address The current contents of the main memory are: Address Instruction LDI 160 ADD 153 STO 153 LDD 160 INC ACC STO 160 JMP 130 … …
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
9
An airline company uses a relational database to store data about passengers and flights. Part of the database is shown. PASSENGER(PassengerID, FirstName, LastName) FLIGHT(FlightID, FlightDate, FlightTime) PASSENGER_LIST(FlightID, PassengerID, SeatNo) Complete the entity-relationship (E-R) diagram to show the relationships between the given tables. PASSENGER FLIGHT PASSENGER_LIST The following is example data for the table FLIGHT: FlightID FlightDate FlightTime MO126 05/05/21 09:00 GK6708 06/09/21 00:30 BA0897 08/12/21 15:30 Write Data Definition Language (DDL) statements to define the table FLIGHT.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open