9608_w18_qp_11
A paper of Computer Science, 9608
Questions:
7
Year:
2018
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
A student is creating a short video and needs to record music to play in the background. The student uses a microphone to capture the music. Explain how the microphone captures the music. An analogue-to-digital converter uses sampling to encode the sound. Explain how different sampling resolutions affect the sound file and the sound it represents. The student needs to edit the sound file. Describe two features of sound editing software that can be used to edit the sound file. Feature 1 Feature 2 The video is recorded with a frame rate of 60 frames per second and uses progressive encoding. Describe what is meant by a frame rate of 60 fps. Describe what is meant by progressive encoding in video recording. MP4 multimedia container format is used to save the video. State what is meant by multimedia container format.
1. Theory Fundamentals  →  1.1. Information representation
Open
2
Computer A needs to access a web page. State how Computer A could access the web page without using a Domain Name Service (DNS). The following table shows four IPv6 addresses. State if each address is valid or invalid. IP address Valid or invalid 21E5:69AA:FFFF:1:E100:B691:1285:F56E ::255.255.255.255 59FB::1005:CC57:6571 56FE::2159:5BBC::6594 The following table shows four statements about either public or private IP addresses. Tick (3) one box in each row to indicate whether each statement refers to a public or a private IP address. Statement Public Private 192.168.2.1 is an example of this type of address Assigned by the Internet Service Provider (ISP) IP address cannot be duplicated in different networks Network Address Translation (NAT) is necessary to access the Internet directly One type of transmission media is copper cable. Give two additional types of transmission media.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
3. Advanced Theory  →  3.2. Communication and Internet technologies
Open
3
Hugo has produced a program for mobile phones. He needs to decide whether to use an Open Source licence or to distribute the app as shareware. Describe what is meant by Open Source licence and shareware. Open Source Shareware Tick (3) one box to indicate the licence Hugo should use. Justify your choice. Open Source Shareware Justification
1. Theory Fundamentals  →  1.7. Ethics and ownership
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
Open
4
The table shows assembly language instructions for a processor which 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 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. STO Store contents of ACC at the given address. ADD Add the contents of the given address to ACC. INC Add 1 to the contents of the register (ACC or . DEC Subtract 1 from the contents of the register (ACC or . CMP Compare contents of ACC with contents of . JPE Following a compare instruction, jump to if the compare was True. JPN Following a compare instruction, jump to if the compare was False. JMP Jump to the given address. OUT Output to the screen the character whose ASCII value is stored in ACC. END Return control to the operating system. State what is meant by direct addressing and indirect addressing. Direct addressing Indirect addressing Explain how the instruction ADD 20 can be interpreted as either direct or indirect addressing. Direct addressing Indirect addressing The assembly language instructions in the following table use either symbolic addressing or absolute addressing. Tick (3) one box in each row to indicate whether the instruction uses symbolic or absolute addressing. Instruction Symbolic Absolute ADD 90 CMP found STO 20 The current contents of a general purpose register (are: X The contents of X represent an unsigned binary integer. Convert the value in X into denary. The contents of X represent an unsigned binary integer. Convert the value in X into hexadecimal. The contents of X represent a two’s complement binary integer. Convert the value in X into denary. The current contents of the main memory, Index Register (and selected values from the ASCII character set are provided with a copy of the instruction set. Address Instruction LDX 200 OUT STO 203 LDD 204 INC ACC STO 204 INC IX LDX 200 CMP 203 JPN 81 OUT LDD 204 CMP 205 JPN 74 END … IX ASCII code table (selected codes only) ASCII code Character ? ! “ * $ & % / Instruction Explanation Op code Operand 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. STO Store contents of ACC at the given address. ADD Add the contents of the given address to ACC. INC Add 1 to the contents of the register (ACC or . DEC Subtract 1 from the contents of the register (ACC or . CMP Compare contents of ACC with contents of . JPE Following a compare instruction, jump to if the compare was True. JPN Following a compare instruction, jump to if the compare was False. JMP Jump to the given address. OUT Output to the screen the character whose ASCII value is stored in ACC. END Return control to the operating system. Instruction set
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
For each of the following scenarios, tick (3) one box for each scenario to indicate whether you think the person’s behaviour is ethical or unethical. Justify your choice. Kevin is a software engineer who has recently started a job with a new company. He is using program code from his previous employer in his new employer’s programs. Ethical Unethical Justification Nadya is a software developer. She has accepted a new job. She has never worked with the programming languages used by this new company. Nadya is planning to increase her knowledge of these programming languages before she starts her new job. Ethical Unethical Justification Maria finds that one of her team members has produced some inventive code. She presents this to her manager, stating that it was produced by the team. She does not mention the individual’s name. Ethical Unethical Justification
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
6
A web page includes the following PHP and HTML code. 08 Enter Age: 12 30) $message = "You are too old"; else $message = "Allowed"; return $message; } 20 ?> Name two identifiers used in the PHP code. Write the value assigned to $message if the user types 30 in the text box. Explain the purpose of the code in line 18. The PHP code in a web page uses server-side scripting. List the sequence of events that take place when a user requests a web page containing PHP code.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
7
A movie theatre has a relational database that stores the movie schedule, and information about the movies. The theatre has several screens that play movies at the same time. The database has three tables to store information about the movies, the screens and the movie schedule. MOVIE(MovieID, Title, Length, Rating) SCREEN(ScreenNumber, NumberSeats) MOVIESCHEDULE(ScheduleID, MovieID, ScreenNumber, Time) Complete the entity-relationship (E-R) diagram to show the relationships between these tables. MOVIE SCREEN MOVIESCHEDULE Explain how primary and foreign keys are used to link the tables in the movie theatre database. The database needs to store the name of the company that produced each movie, for example, Rocking Movies. Write an SQL script to add the attribute ProductionCompany to the MOVIE table. Write an SQL script to display the title and rating of all movies scheduled to play on screen number 3.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open