9608_s15_qp_11
A paper of Computer Science, 9608
Questions:
9
Year:
2015
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
2
Sound can be represented in a computer in a digital format. Give the definition of the term sampling. Give one reason why 16-bit sampling is used in an audio compact disc (CD). Explain what is meant by the term sampling resolution. Give one benefit and one drawback of using a higher sampling resolution. Benefit Drawback Describe two typical features found in software for editing sound files. Explain the difference between lossless and lossy data compression techniques.
1. Theory Fundamentals  →  1.1. Information representation
Open
3
Five modes of addressing and five descriptions are shown below. Draw a line to connect each mode of addressing to its correct description. Mode of addressing Description direct the operand is the address of the address of the value to be used immediate the operand is the address of the value to be used indexed the operand is the offset from the current address where the value to be used is stored indirect the operand plus the contents of the index register is the address of the value to be used relative the operand is the value to be used
4. Further Problem-solving and Programming Skills  →  4.3. Further programming
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
4
Sensors are one type of input device. For each of the following situations, name a different sensor that could be used. air conditioning in an office building maintaining correct growing conditions in a greenhouse detecting an intruder in a building Sensors are used to monitor seismic activity. At the end of each day, all the data are transmitted to a central computer. This is hundreds of kilometres away. Describe one way of ensuring that the integrity of the data is retained during the transmission stage.
3. Advanced Theory  →  3.6. Monitoring and control systems
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
Open
5
Telephone calls can be made by using: • conventional telephones (using the Public Service Telephone Network (PSTN) system) over a wired network • a computer, equipped with speakers and microphone, connected to the Internet Put a tick () in the correct column to match each description to the appropriate communication method. Description Conventional telephone using PSTN Internet-based system connection only in use whilst sound is being transmitted dedicated channel used between two points for the duration of the call connection maintained throughout the telephone call encoding schemes and compression technology used lines remain active even during a power outage Distinguish between the Internet and the World Wide Web (WWW). Name the hardware device that is being described: A device that transfers data from one network to another in an intelligent way. It has the task of forwarding data packets to their destination by the most efficient route. A device used between two dissimilar LANs. The device is required to convert data packets from one protocol to another. A device or software that provides a specific function for computers using a network. The most common examples handle printing, file storage and the delivery of web pages.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
3. Advanced Theory  →  3.2. Communication and Internet technologies
Open
6
Name the most suitable input or output device for each of the following uses. Give a different device in each case. Description of use Input or output device input of credit card number into an online form selection of an option at an airport information kiosk output of a single high-quality photograph output of several hundred high-quality leaflets input of a hard copy image into a computer All of the uses in part involve the input or output of data. Describe two methods of preventing accidental loss of data. Describe one way of ensuring the security of the data against malicious damage.
1. Theory Fundamentals  →  1.3. Hardware
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
Open
7
A system is monitored using sensors. The sensors output binary values corresponding to physical conditions, as shown in the table: Parameter Description of parameter Binary value Description of condition P oil pressure pressure >= 3 bar pressure = 200°C temperature 1000 revs per minute The outputs of the sensors form the inputs to a logic circuit. The output from the circuit, X, is 1 if any of the following three conditions occur: either oil pressure >= 3 bar and temperature >= 200°C or oil pressure 1000 rpm or temperature >= 200°C and rotation > 1000 rpm Draw a logic circuit to represent the above system. P T X R Complete the truth table for this system. P T R Workspace X
3. Advanced Theory  →  3.3. Hardware
1. Theory Fundamentals  →  1.3. Hardware
Open
8
Explain how the width of the data bus and system clock speed affect the performance of a computer system. Width of the data bus Clock speed Most computers use Universal Serial Bus (USB) ports to allow the attachment of devices. Describe two benefits of using USB ports. The table shows six stages in the von Neumann fetch-execute cycle. Put the stages into the correct sequence by writing the numbers 1 to 6 in the right hand column. Description of stage Sequence number the instruction is copied from the Memory Data Register (MDR) and placed in the Current Instruction Register (CIR) the instruction is executed the instruction is decoded the address contained in the Program Counter (PC) is copied to the Memory Address Register (MAR) the value in the Program Counter (PC) is incremented so that it points to the next instruction to be fetched the instruction is copied from the memory location contained in the Memory Address Register (MAR) and is placed in the Memory Data Register (MDR)
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
9
A database has been designed to store data about salespersons and the products they have sold. The following facts help to define the structure of the database: • each salesperson works in a particular shop • each salesperson has a unique first name • each shop has one or more salespersons • each product which is sold is manufactured by one company only • each salesperson can sell any of the products • the number of products that each salesperson has sold is recorded The table ShopSales was the first attempt at designing the database. FirstName Shop ProductName NoOfProducts Manufacturer Nick TX television set refrigerator digital camera SKC WP HKC Sean BH hair dryer electric shaver WG BG John TX television set mobile phone digital camera toaster SKC ARC HKC GK State why the table is not in First Normal Form (1NF). The database design is changed to: SalesPerson (FirstName, Shop) SalesProducts (FirstName, ProductName, NoOfProducts, Manufacturer) Using the data given in the first attempt table (ShopSales), show how these data are now stored in the revised table designs. Table: SalesPerson FirstName Shop Table: SalesProducts FirstName ProductName NoOfProducts Manufacturer A relationship between the two tables has been implemented. Explain how this has been done. Explain why the SalesProducts table is not in Third Normal Form (3NF). Write the table definitions to give the database in 3NF.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open