ITE 152 EXAM 3 (MODULE 9-12) QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026

ITE 152 EXAM 3 (MODULE 9-12) QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026 Which of the following is NOT a part of a database? Records Worksheets Fields Tables - Answers Worksheets What does a filter do? Add to the quantity of data Slow down processing Hide records from view Make more records available - Answers Hide records from view In a database, each _________________ contains a collection of related data. Table Record Field None of the above - Answers Table In a database, a _____________ is a unit of information about one individual or item. Record File Field Table - Answers Record Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on the birthdate field will give him this result? Smallest to largest Largest to smallest A to Z Z to A - Answers Smallest to largest Databases are useful only if they are ___________. Accurate Big Expensive Detailed - Answers Accurate All the pet names in a veterinarian's database are stored in a _______ called PetName. field worksheet table record - Answers field Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem? The table is missing a primary key. The table has been deleted. The table is filtered. The table is sorted. - Answers The table is filtered. A field's data type determines what kind of information can be stored there. True False - Answers True Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar? Inventory Employees Vendors Customers - Answers Vendors Contact information for all the people taking a class at a school are stored in a ________ called Students. record field table worksheet - Answers table This key uniquely identifies each record. Field name primary key unique key key record - Answers primary key Which of the following is the easiest way add data to a table. report query form - Answers Form A computerized database can store millions of telephone numbers. True False - Answers True What are the columns in a Microsoft Access table called? Rows Records Fields Columns - Answers Feilds Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type? Employer Major GPA Graduated - Answers Graduated Malisa is designing a database for a doctor's office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records? Forms Reports Tables Queries - Answers Form Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table would best serve as its primary key? Author ProductID PageCount Title - Answers ProductID A database is an organized collection of information. True False - Answers True Which data type would be best suited to a field that lists a product's clearance price? Currency AutoNumber Number Date/Time - Answers Currency What does SQL stand for? Structured query language Stated question language System query lingo Status query language - Answers Structured query language What is the purpose of Expression Builder in Access? To set a limit to the size of a field To duplicate a field To add comments To create formulas - Answers To create formulas Which of the following is a way to sort data? Chronologically Numerically Alphabetically All of the above - Answers All of the above What is a query? A question you ask a table A question you ask a record A question you ask a database A question you ask a field - Answers A question you ask a database What are the different views to display a table? Datasheet View Design View All of the above - Answers All of the above In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. Record Field File Table - Answers Field Databases typically store their data in one big table. True False - Answers False Which of the following is LEAST likely to be a field in a Customers table? LastName EmploymentDate PhoneNumber Address - Answers EmploymentDate Which field could serve as the primary key for a list of students in your school? Birth date Student ID number Phone number Full name - Answers Student ID number How will you decide which browser security settings to allow and which ones to block? I will need to review each browser security setting and use my best judgement. If the browser security setting is from my favorite online retailers, I will accept it because the retailer knows what I like. If the browser security setting has been mentioned on several friends' timelines on Facebook then it must be a good one, so I should do change it on my computer too. If the browser security setting is on a website sent from a friend, I always accept the setting. - Answers I will need to review each browser security setting and use my best judgement. Each setting will need to be evaluated and you will need to use your best judgement to decide if you should allow or deny the request to access your computer. Which of the following is the strongest password? Welcome123 colorbluesky H@veAGr3atDaY! Test1test2test3 - Answers H@veAGr3atDaY! A strong password is a longer combination of letters, number, and/or symbols that unlocks access to electronic data. How can an attacker execute malware through a script? A script can send you a fraudulent email message requesting confidential information. A script can retrieve and store your personal information, such as your online buying habits. A script searches the Internet for personal information about you. A script can run a series of instructions to download and run malware. - Answers A script can run a series of instructions to download and run malware. An add-on might allow your computer to download a "script" or series of instructions that commands the browser to perform specific actions. An attacker could exploit a security weakness in the add-on to download and execute malware on the user's computer. How can you protect a computer from electrical spikes and surges? Unplug the computer when it is not in use. Use an uninterruptible power supply. Use a cable lock. Use a surge protector. - Answers USe a surge protector A surge protector can defend computer equipment from spikes, surges, and noise. A surge protector lies between the computer and the electrical outlet and absorbs any electrical change so that it does not reach the computer equipment. What would a password manager allow you to do? Create and store multiple strong passwords. Prevent you from using birthdays in your passwords. Test your memorization skills. Make sure you do not repeat passwords on similar accounts. - Answers Create and store multiple strong passwords. With a password manager, you can create and store multiple strong passwords in single user "vault" file that is protected by one strong master password. You can then retrieve individual passwords as needed from the vault, freeing you from the need to memorize passwords. here are various risks from attacks on Wi-Fi networks. These include all of the following EXCEPT _____. viewing or stealing computer data creating malware downloading harmful content reading wireless transmission - Answers creating malware There are several risk from attacks on Wi-Fi networks, such as: reading wireless transmissions; viewing or stealing computer data; injecting malware; and downloading harmful content. Your Facebook profile is private so there is no need to worry about your boss ever seeing your posts such as your Spring Break pictures. True False - Answers False You can choose settings to limit who can see what is posted, but beware who you friend as that can then make private information public. Creating a(n) _____ means copying files from a computer's hard drive and storing them in a remote location. alarm uninterruptible data supply data backup private copy - Answers Data backup Creating a data backup means copying files from a computer's hard drive that are then stored in a remote location. Data backups can save your information from hardware malfunctions, user error, software corruption, and natural disasters. ISabel received a message on her computer that appeared to be from the FBI. It informed her that her computer has been locked and she would need to pay a fee to retrieve her data. How would you describe what is happening? A worm has infected her computer and she needs to unplug her device. A hacker is trying to put a Trojan on her computer. It is most likely ransomware because it is telling her she has to verify payment information to unlock her computer. Nothing has happened and the message is fine to ignore since she has not been home all day and her computer has not been turned on until now. - Answers It is most likely ransomware because it is telling her she has to verify payment information to unlock her computer. Ransomware prevents a user's device from properly and fully functioning until a fee is paid. Most likely, if she called the number, they would try to connect to her computer and then place ransomware software on her computer. How is a worm different from a Trojan? A worm spreads through a network, whereas a Trojan hides inside another program. A worm gathers information and transmits to a server, whereas a Trojan hides and then spreads through a network. A worm reproduces itself on the same computer, whereas a Trojan attempts to spread through the network. A worm prevents a device from functioning until a ransom is paid, whereas a Trojan gathers information and transmits it to another device. - Answers A worm spreads through a network, whereas a Trojan hides inside another program. A worm is a malicious program that attempts to spread. A Trojan is malware that hides inside another program and when it is installed, it gathers information and transmits it to the attacker. Cassidy is a medical assistant in a hospital and has access to many medical files. When she brings patients to the examining room, she can be observed swiping a card, typing in a password, and staring into what appears to be a camera, all attached to the computer. After completing her check-in, Cassidy leaves the patient in the examining room waiting on the doctor. It is important that she logs out of the system so the patient does not have access to the information stored in the hospital's database. Based on Cassidy's actions what systems do you think the hospital has in place to protect the patient medical records? Digital certificates Encryption Two factor authentication Biometrics - Answers Biomentrics The hospital has invested in biometric security, which uses the unique characteristics of the employee's face, hands, or eyes to identify them, so a patient would be locked out. The two-factor authentication system sends a code to a device on the person after they have entered their first password, in this case, her swipe card. Question 120.5 / 0.5 pts Which of the following statements about browser security settings is false? You can allow or block scripts on specific websites. You must keep your accumulated web history as long as you use the browser. You can choose which sites run pop-ups. You can accept or deny cookies. - Answers You must keep your accumulated web history as long as you use the browser. You can either block all pop-ups or accept all pop-ups, and even selectively choose which sites to run pop-ups. Cookies can be accepted or denied. Sites can be allowed or blocked from running scripts. You can configure your wireless router to protect your devices in all of the following ways EXCEPT ____. creating a strong password to access the router utilizing guest access when needed and turning it off when guests leave naming your router something you'll remember, like your street address turning off remote management to the device The wireless router acts a "base station" for the wireless devices, sending and receiving wireless signals between all devices as well as providing the "gateway" to the external Internet. - Answers naming your router something you'll remember, like your street address