9608_s20_qp_13
A paper of Computer Science, 9608
Questions:
7
Year:
2020
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
1
Ana owns a small company with four employees. The office has a network containing several computers that run on a client-server model. There is one server that connects to the Internet using a router. Networks transmit data using various types of connection shown in the following table. Complete the table. Type of connection Description Fibre-optic A communication device in Earth’s orbit that receives and transmits data Radio waves Carries data as electrical signals and can consist of a twisted pair Explain how the client-server model enables the employees to access the same files from different computers. Each computer in the network has a private IP address. Give two reasons why the computers do not have public IP addresses.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
2
Billy has a laser printer. Complete the following description of the basic internal operation of a laser printer. The printer uses a and a rotating to draw the contents of the page on the photosensitive drum as charge. The is attracted to this charge. The laser printer has both RAM and ROM. Describe the purpose of RAM and ROM in the laser printer. RAM ROM Billy’s computer has several ports. State the purpose of a port. Identify one type of port.
1. Theory Fundamentals  →  1.3. Hardware
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
3
The following is a logic expression. X = NOT(A OR B) OR (A AND (B XOR C)) Draw the logic circuit for the given expression, using a maximum of four logic gates. X B A C Complete the truth table for the logic expression: X = NOT(A OR B) OR (A AND (B XOR C)) A B C Working space X The following is a logic expression. A AND B XOR C OR NOT A Identify one logic gate that would not be used in the logic circuit for this expression. Draw the symbol for the logic gate. Logic gate Logic gate symbol:
1. Theory Fundamentals  →  1.3. Hardware
3. Advanced Theory  →  3.3. Hardware
Open
4
Annchi is writing a computer game with a group of friends. One of her friends has suggested using Dynamic Link Library (DLL) files to help them develop the game. Give three reasons why Annchi and her friends should use DLL files when developing the game. Give two reasons why Annchi and her friends should not use DLL files when developing the game. Each member of the group is creating a different part of the game. Each person needs to test their part of the game independently before they are combined. Identify the most appropriate type of translator that should be used to test each part of the game independently. Justify your choice. Translator Justification Annchi needs to decide which type of software licence to use for the game. Give two benefits to Annchi of using a commercial licence. Give one benefit to the customers of the game being released using a commercial licence. Describe one benefit to the customers of the game being released using a shareware licence.
1. Theory Fundamentals  →  1.5. System software
Open
6
Sheila creates a relational database for her hotel using a Database Management System (DBMS). Draw one line from each database term to its most appropriate description. Database Term Description Attribute Primary key Foreign key Entity A field in one table that links to a primary key in another table A collection of records and fields The type of data that is being stored A unique identifier for each tuple A data item, represented as a field within a table The concept or object in the system that we want to model and store information about Identify three tasks that Sheila can perform using the DBMS developer interface. Sheila creates the database HOTEL with the following table structure: ROOM(RoomNumber, RoomType) BOOKING(BookingID, RoomNumber, CustomerID, StartDate) CUSTOMER(CustomerID, FirstName, LastName, Address, Tel_Num) The following table shows some sample data for the table ROOM. RoomNumber RoomType Standard Double Executive Standard Complete the Data Definition Language (DDL) statement to create the table ROOM. TABLE ROOM( RoomNumber Integer, RoomType , (RoomNumber) ); Room number 5 is a Double room. Complete the Data Manipulation Language (DML) statement to add the details for room number 5 to the table ROOM. INSERT ROOM VALUES( ); The table BOOKING needs an additional field to store the number of nights (for example, 3) a customer is staying. Write a Data Definition Language (DDL) statement to add the new field to the table BOOKING.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
7
Xiaoming created the following logo using bitmapped graphics software. PJF Interiors Describe how one typical feature of bitmapped graphics software was used to create the logo. The finished logo is 160 pixels wide and 160 pixels high. The image has a colour depth of 3 bytes per pixel. Calculate an estimate of the file size for the logo. Give your answer in kilobytes. Show your working. Working Answer KB Xiaoming needs to use his logo on his business card, on his website and on large display boards. He is told that he should have created a vector graphic logo instead of a bitmapped graphic logo. Describe one benefit of creating a vector graphic logo instead of a bitmapped graphic logo. The hexadecimal colour value of the background of Xiaoming’s website is: 913C8E Complete the following table by converting each hexadecimal value to denary value. Red Green Blue Hexadecimal value 3C 8E Denary value Part of Xiaoming’s website contains the JavaScript function performTask(). function performTask(){ var value1; value1 = document.getElementById("FirstBox").value; if (value1 == "Yes"){ document.getElementById("paragraph1").innerHTML = "Agreed"; } else if(value1 == "No"){ document.getElementById("paragraph1").innerHTML = "Sorry"; } else { alert("Error") } } Describe the purpose of the following JavaScript statements from the function performTask(). alert("Error") value1 = document.getElementById("FirstBox").value; document.getElementById("paragraph1").innerHTML = "Agreed";
1. Theory Fundamentals  →  1.1. Information representation
Open