Comprehensive IT Quiz Questions and Answers
This content provides a quiz format with questions and answers covering various topics in information technology, such as clock speed, virtual memory, optical storage, network concepts, email protocols, cybersecurity tools, operating system access levels, and artificial intelligence. Additionally, it includes a recap on databases and SQL concepts. The content also showcases examples related to databases and SQL in Python, as well as 2D array practice on tracking computer game usage.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
Quiz 5 - Questions 1.1 What does a clock speed of 2.3 GHz mean? 1.2 What is virtual memory? 1.3 How does optical storage work? 1.4 What is a virtual network? 1.5 Name the protocol responsible for sending emails 1.6 What is the difference between anti-malware software and a firewall? 1.7 Name three user access levels that an operating system can provide? 1.8 What is artificial intelligence?
Quiz 5 - Answers 1.1 What does a clock speed of 2.3 GHz mean? The CPU can run 2.3 billion instructions per second 1.2 What is virtual memory? When the RAM is full a small portion of the secondary storage is used as temporary memory 1.3 How does optical storage work? A laser is shone against a reflective disk if the laser reflects that is a 1, if it hits a burn mark that is a 0 1.4 What is a virtual network? When two or more users use software to make aprivate network over the Internet 1.5 Name the protocol responsible for sending emails. Simple Mail Transfer Protocol 1.6 What is the difference between anti-malware software and a firewall? Anti- malware scans a disk and removes malicious software, firewalls stop it entering in the first place 1.7 Name three user access levels that an operating system can provide? Read only, edit, administrator 1.8 What is artificial intelligence? Any machine or software that is capable of behaving and learning like a human
Recap What is a database? 1) 2) What is data? 3) What is a record? 4) What is a field? 5) What 3 commands are used in an SQL statement?
Recap What is a database? An organised store of data 1) 2) What is data? Information What is a record? One item in a database 3) 4) What is a field? One category of information in a database 5) What 3 commands are used in an SQL statement? SELECT, FROM, WHERE
Databases Name of film Year Age Rating Stars Rating First name Surname DOB Address1 Postcode
SQL SELECT FROM WHERE SELECT what fields do you want to appear? FROM what table do you want to select the fields from? WHERE what condition needs to be met?
Databases in Python Name of film Year Age Rating Stars Rating Star Wars 1977 PG Mark Hamill ***** The Goonies 1985 12 Sean Austin ***** films = [ [ Star Wars , 1977, PG , Mark Hammill , ***** ], [ The Goonies ,1985, 12 , Sean Austin , ***** ] ]
2D Array Practice Heath is researching how long, to the nearest minute, each student in his class spends playing computer games in one week (Monday to Friday). He is storing the data in a 2D array. Fig. 2 shows part of the array, with 4 students. For example, student 1, on Monday (day 0), played 30 minutes of computer games. Heath wants to output the number of minutes student 3 played computer games on Wednesday (day 2). He writes the code: print (hoursPlayed[3,2]). The output is 20. Write the code to output the number of minutes student 0 played computer games on Wednesday. State the output if Heath runs the code: print (hoursPlayed[2,1]) State the output if Heath runs the code: print (hoursPlayed[3,1] + hoursPlayed[3,2]) Write an algorithm to output the total number of minutes student 0 played computer games from Monday (day 0) to Friday (day 4).
1 i print (hoursPlayed[0,2]) 1 Correct Answer Only ii 1 Correct Answer Only iii 80 1 Correct Answer Only Adding all correct elements Outputting correctly Using a loop 1 mark per bullet to a maximum of 3. If used, a flowchart should represent the bulleted steps in the answer column iv 3 e.g. total = 0 for x = 0 to 4 total = total + hoursPlayed[0,x] next x print (total)
