9608_s18_qp_12
A paper of Computer Science, 9608
Questions:
7
Year:
2018
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
An operating system (OS) is usually pre-installed on a new computer. The OS performs a number of different tasks such as file management and peripheral management. State three file management tasks the OS performs. State three printer management tasks the OS performs. Utility software is usually pre-installed on a new computer. The following table lists four programs. Put one tick (3) in each row to indicate whether or not the program is utility software. Program True False Database Virus checker Web browser Backup software Name two other utility programs. Program 1 Program 2
1. Theory Fundamentals  →  1.5. System software
Open
2
A greenhouse control system has four input parameters (H, D, T, W) and two outputs (X, Y). Parameter Description of parameter Binary value Condition H Humidity Too low Acceptable D Day Night Day T Temperature Too high Acceptable W Windows Closed Open The watering system turns on (X = 1) if: either it is daytime and the temperature is too high or the humidity is too low. The fan turns on (Y = 1) if the temperature is too high and the windows are closed. Draw a logic circuit to represent the greenhouse control system. H X Y D T W Complete the truth table for the logic expression: X = NOT A AND (B NAND C) A B C Working space X
1. Theory Fundamentals  →  1.3. Hardware
3. Advanced Theory  →  3.3. Hardware
Open
3
Parity bits can be used to verify data. The following binary number is transmitted using odd parity. Add the missing parity bit. Parity bit In the following data transmitted, the first column contains the parity bits, and the last row contains the parity byte. A device transmits the data using even parity. Circle the error in the data transmitted. Parity bit Data Parity byte The following table shows five error detection measures. Put one tick (3) in each row to indicate whether the measure is validation or verification. Measure Validation Verification Checksum Format check Range check Double entry Check digit
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
3. Advanced Theory  →  3.6. Monitoring and control systems
Open
4
The Accumulator is a register. The current contents of the Accumulator are: The current contents of the Accumulator represent an unsigned binary integer. Convert the value in the Accumulator into denary. Convert the value in the Accumulator into hexadecimal. The current contents of the Accumulator represent a two’s complement binary integer. Convert the value in the Accumulator into denary. The binary integer represents a character from the computer’s character set. Define the term character set. Explain the differences between the ASCII and Unicode character sets. The ASCII code for ‘A’ is 41 in hexadecimal. Calculate the ASCII code in hexadecimal for ‘Z’. Show your working. Working ASCII code in hexadecimal for ‘Z’
2. Fundamental Problem-solving and Programming Skills  →  2.2. Data representation
1. Theory Fundamentals  →  1.1. Information representation
Open
5
A student has recorded a sound track for a short film. Explain how an analogue sound wave is sampled to convert it into digital format. Explain the effects of increasing the sampling resolution on the sound file. The original sound was sampled at 44.1 kHz. The sample rate is changed to 22.05 kHz. Explain the effects of this change on the sound file. The student uses sound editing software to edit the sound file. Name two features of sound editing software the student can use to edit the sound file. Describe the purpose of each feature. Feature 1 Purpose Feature 2 Purpose Question 6 begins on the next page.
1. Theory Fundamentals  →  1.1. Information representation
Open
6
A web page includes the following HTML and JavaScript code. Enter your mark Enter function calcGrade() { var mark, grade; mark = document.getElementById("Mark").value; if (mark >= 90) { grade = "A" } else if (mark >= 80) { grade = "B" } else if (mark >= 70) { grade = "C" } else if (mark >= 60) { grade = "D" } else if (mark >= 50) { grade = "E" } else { grade = "U" } alert("Your grade is " + grade) } Give the identifier of two variables used in the JavaScript code. Give the line number where the JavaScript code produces an output. Describe the purpose of the statement on line 11. State whether this JavaScript code will be run client-side or server-side. Explain the difference between client-side scripting and server-side scripting.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
7
A social media website has a relational database, WEBDATA, that stores the site’s information. The database has three tables to store users’ details, and details of the images and text that they post. USER(UserName, FirstName, SecondName, DateOfBirth) PHOTO(PhotoID, UserName, Comment, UploadDate) TEXTPOST(PostID, UserName, DateOfPost, TheText) Explain how the relationship between the tables USER and PHOTO has been implemented. Draw the entity-relationship (E-R) diagram to show the relationships between the three tables. A database administrator decides to enforce referential integrity. Use an example from the database WEBDATA to explain what is meant by referential integrity. The database has been normalised to Third Normal Form (3NF). Define the three stages of database normalisation. 1NF 2NF 3NF The following shows sample data from the USER table. UserName FirstName SecondName DateOfBirth gem123 John Smith 01/01/1995 purpleSky Muhammed Ali 23/02/1956 OpenWindow Sunny Amir 03/03/1997 bluebird127 Raziya Bello 04/03/1982 Write an SQL script to create the USER table. The database administrator needs to alter the USER table. A new field, Country, needs to be added. Write an SQL script to add the field Country to the USER table.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open