Ultimate Computer science revision 0.0 / 5 ? ComputingDatabasesA2/A-levelOCR Created by: J@ckCreated on: 04-11-21 13:31 How many bits are there in ASCII 8 1 of 34 How many instructions can ASCII produce 127 2 of 34 How Many bits can Unicode use? It can use varying quantities of Bits 3 of 34 Why was Unicode created? To compensate for other languages such as Arabic 4 of 34 Why was extended Unicode invented? To compensate for accented characters 5 of 34 What type of storage device would be used for body cams in extreme stunts? Solid state Storage 6 of 34 What does optical storage use to store information? Pit and lans 7 of 34 Select the storage device with no moving mechanical parts Magnetic storage 8 of 34 If a binary number ends in 0 it is a... Even number 9 of 34 Select the correct order of the layers if a device was RECEIVING a file Network layer, Data link Layer, Transport, Application 10 of 34 What is 011010 in denary 26 11 of 34 What is 011011 minus 011010. Select answer in denary 1 12 of 34 Where may be lossy compression be suitable Photos 13 of 34 Define redundant data Data that repeats within a database 14 of 34 what is 30 in binary 011110 15 of 34 Define a primary key A key gives all entities with a database a unique identifier. 16 of 34 Define a foreign key A key that is used to make the relationship between two tables that have linked data. 17 of 34 Define a secondary key An addition that is used to support the primary key 18 of 34 Define Von Neuman architecture A computer model that only has one RAM and can only process one instruction at a time 19 of 34 Define Harvard architecture A model that can execute an instruction in just one cycle and can perform paralleled processing. 20 of 34 What is the drawback of using a core to improve processing speed? By adding a entire new CPU into the system, more wiring will haft to be in place, hence it will take longer for buses to transmit information 21 of 34 What is the drawback of having a faster bus? in the process of making the bus faster, one could make it less able to transmit information 22 of 34 The program counter is used when the next instruction is fetched. What is the purpose of the program counter: The program counter assigns an address value in the memory of where the next instruction is 23 of 34 The memory address register does what? Contains the address of the instruction that is currently being 24 of 34 What is the purpose of the memory data register? This register of the computer's control unit contains the information to be stored in the computer storage 25 of 34 Select the float: 23.99 26 of 34 Select the string "Hello_World" 27 of 34 Select the integer 23 28 of 34 Which Network layer is responsible for assigning the routes to the packets Network layer 29 of 34 Which layer is responsible for dividing the message into the packets Transport layer 30 of 34 SELECT column1, column2, ... FROM table_name; What is this staement doing? Selecting the desired data from the column 1 and 2 and presenting it 31 of 34 SELECT * FROM table_name; What would this statement do? Select all the data from the table 32 of 34 When would the Command WHERE be used in a SQl staement When two databases are present 33 of 34 If I wanted to change data within a database, what would I use instead of SELECT UPDATE and SET 34 of 34
Comments
No comments have yet been made