9608_w16_qp_12
A paper of Computer Science, 9608
Questions:
9
Year:
2016
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
When recording a video, state what is meant by frame rate. Video streaming can use either interlaced encoding or progressive encoding. Describe what is meant by the following terms. Interlaced encoding Progressive encoding Name the video terms described below: Description Term Pixels in two video frames have the same value in the same location. There is duplication of data between frames. A sequence of pixels in a single video frame have the same value. Give one file technique that could be applied when either of the two features, described in part , are present.
1. Theory Fundamentals  →  1.1. Information representation
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
3
When an application program requests a file stored on a hard disk, the computer system reads the file. Use the statement labels A to H to complete the sequence of steps that describe how this happens. Label Statement A When the hard disk drive has read the file, it generates an interrupt. B While the file continues, the head reads successive clusters of sectors from the disk and writes data into the disk buffer. C The head reads the first cluster of sectors from disk and writes data into the disk buffer. D The head moves to the correct track. E The operating system transfers the contents of the disk buffer to the application program’s data memory. F In the relevant directory file, the operating system looks up the track and sector where the file begins. G Application program passes file read request to the operating system. H The hard disk drive waits for the correct sector to arrive under the head. 1. The application program executes a statement to read a file. 2. 3. The operating system begins to spin the hard disk, if it is not currently spinning. 4. 5. 6. 7. 8. 9. 10.
4. Further Problem-solving and Programming Skills  →  4.3. Further programming
3. Advanced Theory  →  3.1. Data representation
Open
5
The table shows assembly language instructions for a processor that 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 given address to ACC. LDX Index addressing. Form the address from + the contents of the index register. Copy the contents of this calculated address to ACC. LDI Indirect addressing. The address to be used is at the given address. Load the contents of this second address to ACC. STO Store the contents of ACC at the given address. INC Add 1 to contents of the register (ACC or . ADD Add the contents of the given address to the ACC. END Return control to the operating system. The diagram shows the contents of a section of main memory: Main memory 0000 0010 1001 0011 0111 0011 0110 1011 0111 1110 1011 0001 0110 1000 0100 1011 … 1001 1110 Show the contents of the Accumulator after the execution of the instruction: LDD 102 ACC: Show the contents of the Accumulator after the execution of the instruction: LDX 101 IX: ACC: Explain how you arrived at your answer. Show the contents of the Accumulator after the execution of the instruction: LDI 103 ACC: Explain how you arrived at your answer. Complete the trace table below for the following assembly language program. LDD 810 INC ACC STO 812 LDD 811 ADD 812 STO 813 END … Trace table: ACC Memory address
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
9
A health club offers classes to its members. A member needs to book into each class in advance. The health club employs a programmer to update the class booking system. The programmer has to decide how to store the records. The choice is between using a relational database or a file-based approach. Give three reasons why the programmer should use a relational database. The programmer decides to use three tables: MEMBER, BOOKING and CLASS. Complete the Entity-Relationship (E-R) diagram to show the relationships between these tables. MEMBER CLASS BOOKING The CLASS table has primary key ClassID and stores the following data: ClassID Description StartDate ClassTime NoOfSessions AdultsOnly DAY01 Yoga beginners 12/01/2016 11:00 TRUE EVE02 Yoga beginners 12/01/2016 19:00 FALSE DAY16 Circuits 30/06/2016 10:30 FALSE Write an SQL script to create the CLASS table.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open