WorksheetsINFORMATION TECHNOLOGY: PAPER II
Total questions: 20
Worksheet time: 3600secs
Give the most appropriate term for each of the following expressions: 1.1 A program which converts source code into machine code, line by line. 1.2 The part of the machine cycle which translates the instruction into CPU commands. 1.3 A form of network transmission where packets are transmitted to all nodes on the network rather than a specific device. 1.4 A memory management technique where secondary storage can be used as if it were main memory. 1.5 Reorganising the data stored on an HDD into contiguous blocks. 1.6 The portion of a packet which contains the data being transmitted. 1.7 An older communications technology which simultaneously transmits voice and data over public telephone networks using copper cable. 1.8 Software which protects a computer against malicious programs.
For each of the terms in Column A below, you should select the most correct definition in Column C, matching the letter to the question number. You should merely write down the appropriate letter in Column B. An example is shown as Question 2.0, using 'W' as the correct answer. Column A Column B Column C 2.0 W 2.1 SSD A A motherboard path which connects the CPU and main memory 2.2 Register B A computer interface used to connect storage devices 2.3 CMOS C A portion of the CPU used to store the current instruction 2.4 IO Range D A semiconductor chip which stores instructions to load the basic computer hardware on start-up 2.5 Virtual memory E A software license which allows free use of software 2.6 Compiler F A list of the available IRQs a device can use 2.7 BIOS G A form of cloud storage 2.8 Freemium H Converting and executing source code line by line 2.9 SATA I A semiconductor chip which stores computer configuration data 2.10 FSB J An interface which allows hot swappable devices to connect with the motherboard K Software used to convert source code into object code L A storage device which has no mechanical parts M A technology which allows segments of memory to be stored in pages on a hard drive N A buffer used to speed up a slow input-output device O A software license which allows free use of restricted features of software P The temporary storage of hard drive data in RAM to increase secondary storage access speed
The business owners will need various computer hardware items for the fitness centre. To reduce start-up costs, they have purchased a second-hand server with the following specifications: • Intel Xeon CPU 8 cores 3.3 Ghz • 2 CPU slots (1 filled) • 20 MB L3 cache • DDR3 RAM • 8 RAM slots • 3 x 2 TB HDD • Supported RAM chips: 2 GB, 4 GB, 8 GB, 16 GB and 32 GB • 4 × USB 3 slots • Intel onboard graphics card 3.1 Give an example of ONE device which will connect to a server via USB. 3.2 The specification doesn't state how much RAM there is on the motherboard. What is the maximum amount of RAM which can be installed using: RAM chip capacity Total amount of RAM 2 GB 32 GB
For questions 4.1 to 4.5, you need to select the most correct answer from the options A–D. An answer grid is at the bottom of this page for your answers. You merely need to write down the appropriate letter for your answer. 4.1 DHCP ... A is a protocol used to setup transmission security. B is a protocol used to allocate IP addresses to devices. C is a protocol to allow data transfer on mobile networks. D is a protocol used to link URLs and IP addresses. 4.2 Thin clients ... A are only used on cabled networks. B are used to reduce server processing requirements. C are devices with minimal processing ability. D are commonly used in most school networks. 4.3 MAC addresses ... A uniquely identify network cards. B uniquely identify nodes on a network. C uniquely identify switch ports. D None of the above. 4.4 Ethernet ... A is a commonly used LAN protocol. B uses ARP (Address Resolution Protocol) to identify devices. C allows for different transmission speeds on the same network. D All of the above. 4.5 Video on demand ... A can only be offered on a cabled network. B eliminates the constraint of static broadcast schedules. C always uses the UDP protocol for transmission. D is usually offered as a free service.
What is the function of a wireless access point?
What is meant by the term 'encrypted' when referring to network traffic?
What is the purpose of a firewall in a network?
Explain what each of the following threats to quality
Explain what each of the following threats to quality data means and give a possible example of how customer data could be affected in the Fairly Fit database. Outdated data
Explain what each of the following threats to quality data means and give a possible example of how customer data could be affected in the Fairly Fit database. Invalidated data
Entering a SQL statement into a web page field is a malicious SQL technique. What name is given to this technique?
Explain what this line of SQL code will achieve.
Why will this achieve what you have explained in (b) above?
What can be done to ensure that a SQL statement such as that shown in part (b) above is not executed?
How many bits will be required to store one IPv6 address?
Write out this IPv6 address in shortened format using the technique described above. The first two fields are shown for you.
The shortening technique used above suppressed leading zeros. Why is it not possible to remove trailing zeros as well? Use the field ff00 to assist in answering this question if necessary.
What method will be called to access the value of the variable totalStock?
Explain what is wrong with this line of code.
Correct the line of code so that the correct result will be achieved.
