1.2. Communication and Internet technologies
A subsection of Computer Science, 9608, through 1. Theory Fundamentals
Listing 10 of 44 questions
Downloading a file from a website is an example of a client-server application. Describe what is meant by the term client-server for this application. The following sequence of steps (1 to 5) describes what happens when someone uses their personal computer (PC) to request a web page. The web page consists of HTML tags and text content only. Four of the statements from A, B, C, D, E and F are used to complete the sequence. A Browser software interprets the script, renders the page and displays. B Browser software renders the page and displays. C Browser software compiles the script, renders the page and displays. D The web server retrieves the page. E The Domain Name Service (DNS) uses the domain name from the browser to look up the IP address of the web server. F The web server sends the web page content to the browser. Write one of the letters A to F in the appropriate row to complete the sequence. 1. The user keys in the Uniform Resource Locator (URL) into the browser software. 2. 3. 4. 5. The following web page used for data capture consists of: • two text boxes for the entry of: ° a race runner’s ID code ° their finishing position in a race. • a button that the user clicks to submit this runner’s result. Untitled Document function myButton_onmousedown() { var Output1 = "Runner ID OK"; var Output2 = "ERROR – entry refused"; var Runner ID = document.forms["form1"]["txtRunnerID"].value; // || in Javascript is the 'OR' operator if (RunnerID.substr(0,3) == "VAR" || RunnerID.substr(0,3) == "CAM") { alert(Output1) } else { alert(Output2) } } Runner ID: Position: Save data: The developer has used three variables in the JavaScript code. State the identifiers used. 1. 2. 3. The button has an event whose identifier is onMouseDown. When the mouse button is clicked, some code is run. State the line numbers which contain this code. From line to line The JavaScript code uses a selection statement. State the line number which contains its condition. Line number: Describe the purpose of the validation check that the code performs. Name and describe two other types of validation check which could be appropriate for this data capture form. Validation check: Description Validation check: Description
9608_s17_qp_12
THEORY
2017
Paper 1, Variant 2
Customers of a bank can access their account information by logging in on the bank’s website. The bank has a client-server model of networked computers. Describe, using the bank as an example, the key features of a client-server model. Give two other examples of applications that can use the client-server model. The bank’s customers log in to the website using a web application. Explain why the web application uses server-side scripting. The bank is upgrading its local area network (LAN) copper cables to fibre-optic cables. State two benefits to the bank of upgrading to fibre-optic cable from copper cable. State two drawbacks of upgrading to fibre-optic cables. The bank uses a relational database, ACCOUNTS, to store the information about customers and their accounts. The database stores the customer’s first name, last name and date of birth. The bank has several different types of account. Each account type has a unique ID number, name (for example, regular or saving) and bonus (for example, $5.00, $10.00 or $15.00). A customer can have more than one account. Each customer’s account has its own ID number and stores the amount of money the customer has in that account. The bank creates a normalised, relational database to store the required information. There are three tables: • CUSTOMER • ACCOUNT_TYPE • CUSTOMER_ACCOUNT Write the attributes for each table to complete the database design for the bank. CUSTOMER( ) ACCOUNT_TYPE( ) CUSTOMER_ACCOUNT( ) Identify the primary key for each table that you designed in part . CUSTOMER ACCOUNT_TYPE CUSTOMER_ACCOUNT Identify one foreign key in one of the tables that you designed in part . Table name Foreign key The following table has definitions of database terms. Write the correct database term in the table for each definition. Definition Term All the data about one entity The data in one row of a table A column or field in a table
9608_w19_qp_11
THEORY
2019
Paper 1, Variant 1
Questions Discovered
44