9608_s21_qp_13
A paper of Computer Science, 9608
Questions:
9
Year:
2021
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
An adventure sports company has a website. Customers can book courses using an online booking form. The booking form contains a number of fields. The following table gives a description of the validation for each field. Write the validation type for each validation description in the table. Field Validation description Validation type Name A name must be entered Date of Birth Entered as dd/mm/yyyy Telephone Number A limit of 15 characters can be entered Experience Level Only values between 1 and 5 can be entered Validation is one way to protect the integrity of input data. Identify one other method to protect the integrity of input data. The data input will be transferred to a central server. Identify two measures to protect the integrity of the data during transfer.
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
Open
3
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 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. DEC Subtract 1 from the contents of the register (ACC or . JMP Jump to the given address. CMP Compare the contents of ACC with the contents of . JPE Following a compare instruction, jump to if the compare was True. OUT Output to the screen the character whose ASCII value is stored in ACC. END Return control to the operating system. The current contents of the main memory and selected values from the ASCII character set are: Address Instruction ASCII code table (selected codes only) LDR #2 ASCII code Character LDX 180 $ CMP #0 ( JPE 82 ) OUT + DEC IX E JMP 76 F END G … Complete a trace table for the execution of the program. Instruction address IX ACC Memory address Output Identify two modes of addressing that are not used in the assembly language program given. Each instruction in the assembly language program is encoded in 16 bits (8-bit op code followed by an 8-bit operand). The instruction LDX 234 has the operand 234. Convert the operand 234 into 8-bit binary. Convert the denary value 234 into hexadecimal. The contents of memory address 190 represent a two’s complement binary integer. Address Convert the value in memory address 190 into denary. The fetch-execute (FE) cycle is shown in register transfer notation. Complete the FE cycle using register transfer notation. ← [PC] PC ← + 1 MDR ← [[MAR]] ← [MDR]
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
4
An operating system (OS) is installed on a computer. The OS performs a number of different tasks such as device management and error detection and recovery. State three device management tasks the OS performs. State three error detection and recovery management tasks the OS performs. State two tasks, other than device management and error detection and recovery management that are carried out by an OS. Utility programs are installed on a new computer. The following table lists six programs. Tick (3) one box in each row to identify whether the program is a utility program or not a utility program. Program Utility Not utility Language translator Backup Integrated Development Environment (IDE) Graphics Defragmenter Spreadsheet Identify two other utility programs.
1. Theory Fundamentals  →  1.5. System software
Open
5
A web page staff.html contains the following HTML and PHP code. 03 Current Staff 05 Staff list"; 07 echo ""; 09 $first_name="Jason"; 10 $last_name="Chan"; 12 $result = $first_name." ".$last_name; 13 echo $result; 14 ?> Give the identifier of two variables used in the PHP code. The PHP code produces multiple outputs. Give all the line numbers where the PHP code produces an output. Describe the purpose of line 12 of the code.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
2. Fundamental Problem-solving and Programming Skills  →  2.3. Programming
Open
6
A customer completes a booking form on a web page and clicks a submit button to submit the form. The following sequence (1 to 6) describes the steps that take place when the form is submitted. The form data is transmitted to the web server The HTML code is returned to the browser Write one of the letters A to D in each row (1, 3, 4 and 6) to complete the sequence. A The browser displays the web page B Server-side code is processed C Client-side code is processed D The web server produces the HTML code The web page 9608.html is accessed from the URL: https://www.cambridgeinternational.org/9608.html An employee of the company states, “A Domain Name and an IP address are exactly the same thing”. State whether this statement is true or false and justify your choice.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
7
Patrick is writing a new software application. He is using a compiler to develop the software application. Describe the drawbacks of using a compiler instead of an interpreter. Patrick has completed the application. He needs to choose whether to distribute the software application using an open source licence or a commercial licence. Describe open source and commercial software licensing. Open source Commercial Patrick works for a company that has a code of conduct for its employees. Explain the reasons why the company needs a professional code of conduct.
1. Theory Fundamentals  →  1.5. System software
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
8
A charity has a relational database, CHARITY_PROJECT. The database has three tables to store information about the charity’s employees, the projects and the project teams. EMPLOYEE(EmployeeID, FirstName, LastName, Salary, DOB) PROJECT(ProjectID, Name, Location, ProjectStartDate) PROJECT_TEAM(EmployeeID, ProjectID, JoinedProjectDate) Complete the entity relationship (E-R) diagram to show the relationships between these tables. EMPLOYEE PROJECT PROJECT_TEAM Explain how primary and foreign keys are used to link the tables in CHARITY_PROJECT. The database needs to store the gender of each employee (either M for Male or F for Female). Write a Data Definition Language (DDL) statement to add the attribute Gender to the EMPLOYEE table. Part of the EMPLOYEE table is shown: EmployeeID FirstName LastName Salary DOB Gender Jasmine Chen 25 000 25/12/2000 F Kenton Archer 20 000 01/04/1993 M Michael Roux 10 000 10/03/1990 M Conrad Slavorski 15 000 30/03/1989 M Each employee is paid a salary in dollars ($). Write a Data Manipulation Language (DML) statement to return the first name, last name and salary of all employees that are paid more than $17 500.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
9
A website streams music and videos. Two descriptions about how sound is encoded and represented on a computer are given. Give the correct term for each description. “The number of samples taken per unit time” Term “The number of bits used to encode each sample” Term Videos on the website are compressed. Compression algorithms can use spatial redundancy or temporal redundancy. Describe spatial redundancy and temporal redundancy. Spatial Temporal
1. Theory Fundamentals  →  1.1. Information representation
Open