Question Constellation Sign up for free AQA · GCSE · Computer Science
Paper 2 Computing concepts
06.0 · 2 marks Megabytes-to-bits storage conversion Calculate the number of bits in 7 MB. Show your working. 07.1 · 1 mark Logic-gate truth-table matching Which truth table matches the logic gate in Figure 4? Shade one lozenge. 07.2 · 3 marks Circuit construction from truth table Complete the logic circuit by writing the name of a logic gate in each empty box. The completed logic circuit should have the... 07.3 · 3 marks Boolean expression from logic circuit Write a Boolean expression that represents the logic circuit shown in Figure 6. You must use the correct symbols for the Boolean... 08.1 · 6 marks Functions of CPU components Describe the function of each of the three components. 08.2 · 3 marks CPU performance improvement methods Explain three ways to improve the performance of a CPU. 09.1 · 2 marks Huffman bit-pattern decoding State the string that this bit pattern represents. 09.2 · 3 marks Huffman versus ASCII savings calculation Calculate how many bits would be saved if the string HESELLSSEASHELLASHES was encoded using the Huffman codes shown in Table 1... 10.0 · 2 marks Machine code properties Which two statements are true about machine code? Shade two lozenges. 11.0 · 3 marks High-level and low-level language differences Describe three differences between high-level programming languages and low-level programming languages. 12.0 · 6 marks Compiler and interpreter operation Describe how compilers and interpreters operate. 13.1 · 2 marks Computer network definition Define the term computer network. 13.2 · 6 marks School network advantages and disadvantages Discuss the advantages and disadvantages to the school, staff and students of having the computers installed in a network. 14.0 · 2 marks SMTP and IMAP email roles Describe how SMTP and IMAP are used. 15.0 · 2 marks Encryption during data transmission Describe how encryption can make the transmission of data more secure. 16.0 · 4 marks Blagging and phishing characteristics Describe blagging and phishing. 17.0 · 4 marks Malware operation descriptions Describe how two of these forms of malware work. 18.1 · 1 mark Meaning of database Define the term database. 18.2 · 2 marks Data inconsistency definition Explain what is meant by data inconsistency within a database. 18.3 · 2 marks Foreign key definition Define the term foreign key. 18.4 · 1 mark Actor table field identifiers State the identifier of a field from the Actor table in Figure 8. 18.5 · 2 marks SQL SELECT query completion Some parts of the SQL have been replaced by labels. State the SQL that should have been written in place of the labels A and B. 18.6 · 3 marks SQL UPDATE query construction Write the SQL to make this change. 18.7 · 3 marks SQL INSERT query completion Some parts of the SQL have been replaced by labels. State the SQL that should have been written in place of the labels A, B and C.