9608_s21_qp_11
A paper of Computer Science, 9608
Questions:
9
Year:
2021
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Draw one line from each software licence to its correct description. Software licence Description A limited version of the software could be released and downloaded by anyone, but users would need to pay to unlock additional features. Shareware A licence must be purchased to use the software. Open Source Users cannot download the software over the Internet. Commercial The original source code is made available for other developers who can then modify and improve the software.
1. Theory Fundamentals  →  1.7. Ethics and ownership
1. Theory Fundamentals  →  1.5. System software
Open
2
Zak designs a logo for his company. He uses vector graphics software to create the logo. One of the drawing objects in the logo is a circle. Identify four properties of the circle. Describe what is meant by a drawing list using the logo as an example. Zak could have used a bitmapped image for the logo. Describe two drawbacks of using a bitmapped image for the logo instead of a vector graphic. Drawback 1 Drawback 2 Zak’s company holds details about clients in a database. Give three security measures that Zak can implement to make sure that only authorised employees can access the data.
1. Theory Fundamentals  →  1.1. Information representation
Open
3
The 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 LDD Direct addressing. Load the content of the location at the given 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. DEC Subtract 1 from the contents of the register (ACC or . CMP Compare the contents of ACC with the contents of . JMP Jump to the given address. JPE Following a compare instruction, jump to if the compare was True. STO Store the contents of ACC at the given address. END Return control to the operating system. The current contents of the main memory are: Address Instruction LDD 200 CMP 201 JPE 106 DEC ACC STO 200 JMP 101 END … Trace the program currently in memory using the following trace table. Instruction address ACC Memory address The instruction in memory address 100 needs to be changed. It needs to use indirect addressing to load the contents of memory address 200. Give the new instruction to replace LDD 200. Each instruction in the assembly language program is encoded in 16 bits (8-bit op code followed by an 8-bit operand). The instruction CMP 201 has the operand 201. Convert the operand 201 into 8-bit binary. State the maximum number of op codes that can be represented using eight bits. The status register contains condition flags. Identify three condition flags that can be set in the status register.
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
A company runs activity courses. It is creating a relational database to store details of the courses it runs. The database has five tables: EMPLOYEE(EmployeeID, FirstName, LastName, Role, Language) BOOKING(BookingID, CustomerID, CourseID) CUSTOMER(CustomerID, FirstName, LastName) COURSE(CourseID, Title, Level, Date) COURSE_EMPLOYEE(CourseID, EmployeeID) Complete the entity relationship (E-R) diagram for the database. COURSE BOOKING CUSTOMER COURSE_EMPLOYEE EMPLOYEE Describe what is meant by referential integrity. Give an example from the CUSTOMER and BOOKING tables in your answer. A Data Definition Language (DDL) is used to create the structure of the database. One item that can be created is the database. Identify three other items that can be created in the database using the DDL. Part of the EMPLOYEE table is shown. EmployeeID FirstName LastName Role Language Jasmine Chen Leader French Kenton Archer Leader English Michael Roux Cook French Conrad Slavorski Leader Russian Write a Data Manipulation Language (DML) statement to return the first name and last name of all employees, who are leaders, and speak either French or English.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
6
A web page includes HTML, JavaScript and PHP code. 11 24 hour clock hour 12 Enter function timeOfDay() { var hour, greeting; hour = document.getElementById("Time").value; if (hour The page is loaded and the value 16 is entered. State the output when the enter button is clicked. Give the line number where the JavaScript function is called. Give the identifier names of two variables used in the JavaScript code. Tick (3) one box in each row to indicate whether each of the following statements is true or false. Statement True False The program contains client-side and server-side code The PHP code in the program will run on the client-side Line 19 of the code outputs the message "Good day" Line 18 of the code contains a conditional statement Examine the following list of terms: bandwidth browser compiler HTML interpreter JavaScript PHP router server server-side transmission validation Complete the following sentences by filling in the missing terms from the list. Some terms may be used more than once. Some terms are not used. can be performed both client-side and server-side. It is performed more rapidly by the because there is no delay in transmitting and receiving data to and from the . It is also performed on the server-side, because the client’s may not support , so the data will still need checking to avoid errors.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
7
This question presents three scenarios. Tick (3) one box for each scenario to indicate whether you think the behaviour shown is ethical or unethical. Justify your choice. Marina has a very short deadline to create a piece of software for a client. Algorithm A is quick to code and simpler to test but has an inefficient run time. Algorithm B is more complex to code and test but has a more efficient run time. She decides to implement algorithm A. Ethical Unethical Justification Doug is managing a project for a client that has fallen behind schedule. He asks all members of the project team to work extra hours and to cancel any holiday plans to get the project back on schedule. Ethical Unethical Justification Debbie is programming a car safety management system. She thinks that the test plan she has been given is not adequate. She decides to discuss her concerns on a public internet forum. Ethical Unethical Justification
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
8
Jay is developing a computer game that allows users to create stories. Jay uses a language translator to develop the computer game. Tick (3) one or more boxes in each row to identify the language translatoreach statement describes. Statement Assembler Interpreter Compiler Translates and executes each line of source code one line at a time Translates low-level source code into machine code Must be present in memory to execute the code Translates high-level source code into low-level code Jay decides to use a compiler to develop the game. Identify two benefits of using a compiler. Benefit 1 Benefit 2 The game generates a story which is stored as a text file. Jay compresses the text file using lossless compression before sending it by email to his friend. Identify two reasons for compressing the text file. Explain the reasons why Jay compresses the text file with lossless compression instead of lossy compression.
1. Theory Fundamentals  →  1.5. System software
2. Fundamental Problem-solving and Programming Skills  →  2.4. Software development
Open
9
Identify two differences between a public IP address and a private IP address. Complete the table by identifying the most appropriate term for each description. Each term must be different. Description Term Receives data packets from a network and forwards them onto a similar network Manages access to a centralised resource Joins networks that use different sets of rules to transmit data Monitors and controls incoming and outgoing network traffic based on set criteria
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
3. Advanced Theory  →  3.2. Communication and Internet technologies
Open