ITE 152 Exam 3 | Answered with complete solutions

ITE 152 Exam 3 | Answered with complete solutions (mod 9) 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? A. Major B. GPA C. Graduated D. Employer (mod 9) Which data type would be best suited to a field that lists customer email addresses? A. Hyperlink B. Date/Time C. Number D. AutoNumber (mod 9) What are the different views to display a table? A. All of the above B. Datasheet View C. Pivot Table & Pivot Chart View D. Design View (mod 9) All the pet names in a veterinarian's database are stored in a _______ called PetName. A. table B. worksheet C. field D. record (mod 9) A relationship is created between how many tables? A. Two B. Three C. Any number D. One (mod 9) A database is an organized collection of information (T/F) True (mod 9) What is a query? A. A question you ask a field B. A question you ask a table C. A question you ask a record D. A question you ask a database (mod 9) Contact information for all the people taking a class at a school are stored in a ________ called Students. A. worksheet B. record C. table D. field (mod 9) 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? A. ProductID B. Title C. PageCount D. Author (mod 9) In a database, each _________________ contains a collection of related data. A. Table B. Field C. Record D. None of the above (mod 9) Which of the following is LEAST likely to be a field in a Customers table? A. LastName B. EmploymentDate C. PhoneNumber D. Address (mod 9) 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? A. Smallest to largest B. Z to A C. Largest to smallest D. A to Z (mod 9) In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. A. Table B. Field C. Record D. File (mod 9) A field's data type determines what kind of information can be stored there (T/F) True (mod 9) A computerized database can store millions of telephone numbers (T/F) True (mod 9) Queries in access can be used A. Only 'a' B. as a source of records for forms and reports C. Both 'a' and 'b' D. to view, change and analyze data in different ways (mod 9) Which data type would be best suited to a field that lists a product's clearance price? A. Currency B. Date/Time C. AutoNumber D. Number (mod 9) 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? A. Forms B. Reports C. Queries D. Tables (mod 9) Databases typically store their data in one big table (T/F) False (mod 9) What does SQL stand for? A. Stated question language B. Structured query language C. System query lingo D. Status query language (mod 9) Which of the following is NOT a part of a database? A. Records B. Fields C. Worksheets D. Tables (mod 9) What are the columns in a Microsoft Access table called? A. Fields B. Rows C. Records D. Columns (mod 9) What does a filter do? A. Slow down processing B. Make more records available C. Hide records from view D. Add to the quantity of data (mod 9) One disadvantage of computerized databases is that they limit your ability to arrange information (T/F) False (mod 9) A query lets you speed up the browsing process by finding information that matches specifically to your criteria (T/F) True (mod 9) 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? A. Inventory B. Vendors C. Customers D. Employees (mod 9) A database is a collection of related information, but a database management system is a type of software program (T/F) True (mod 9) 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? A. The table is missing a primary key. B. The table has been deleted. C. The table is sorted. D. The table is filtered. (mod 9) Which field could serve as the primary key for a list of students in your school? A. Phone number B. Full name C. Student ID number D. Birth date (mod 9) Which of the following is a way to sort data? A. Chronologically B. Alphabetically C. Numerically D. All of the above (ch. 6) How can an attacker execute malware through a script? A. A script can run a series of instructions to download and run malware. B. A script can send you a fraudulent email message requesting confidential information. C. A script searches the Internet for personal information about you. D. A script can retrieve and store your personal information, such as your online buying habits. (ch. 6) There are various risks from attacks on Wi-Fi networks. These include all of the following EXCEPT _____. A. reading wireless transmissions B. downloading harmful content C. viewing or stealing computer data D. creating malware (ch. 6) How does discarding computers in a landfill affect the environment? A. Lead and mercury in computer parts are seeping into the ground and water supply. B. Copper on circuit boards is creating fire hazards. C. The computer parts quickly decay and become organic material D. Data miners are digging up landfills looking for gold and platinum. (ch. 6) 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? A. Biometrics B. Two factor authentication C. Encryption D. Digital certificates (ch. 6) Why is it not safe to connect to public Wi-Fi networks? A. Because the connection is often too slow B. Because these networks are rarely protected C. Because it can weaken your own Wi-Fi wireless router D. Because they do not allow Internet access (ch. 6) _____ ensures that the person requesting access to a computer is not an imposter. A. Authentication B. Encryption C. Automatic encoding D. Data mining (ch. 6) Which term refers to the science that specifies the design and arrangement of items you use so you interact with the items efficiently and safely? A. Technology addiction B. Repetitive strain C. Ergonomics D. Cyberbullying (ch. 6) To protect your information and help you to remember passwords, use your social media account login information to log into another site (T/F) False (ch. 6) How will you decide which browser security settings to allow and which ones to block? A. If the browser security setting is on a website sent from a friend, I always accept the setting. B. If the browser security setting is from my favorite online retailers, I will accept it because the retailer knows what I like. C. 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. D. I will need to review each browser security setting and use my best judgement. (ch. 6) Which of the following is the strongest password? A. colorbluesky B. H@veAGr3atDaY! C. Welcome123 D .Test1test2test3 (ch. 6) Marcus recently had his cell phone stolen. All of the following are security features that should help him locate his stolen phone EXCEPT which one? a. If the thief enters an incorrect passcode three times, the phone takes a picture of the thief and emails it to Marcus. B. The current location of his phone can be pinpointed on a map through the phone's GPS. C. His phone can generate an alarm even if it is on mute. D. He can use remote tracking to retrace the thief's steps. (ch. 6) What type of security requires something you know and something you have that no one else has? A. data mining B. two part passwords C. two factor authentication D. biometric security (ch. 6) Which of the following is a characteristic of a strong password? A. letters, numbers, and symbols B. numbers in a series C. personal information D. A short phrase (ch. 6) How does encryption work? A. It scrambles the information until the key is used to unscramble it. B. It is a key that you insert into your computer to unlock your saved files. C. It is what happens when you download attachments from your email. D. It protects data on your hard drive, but once you choose to send it to someone, it is no longer protected. (ch. 6) Which of the following types of websites typically provides the least security? A. social media sites B. online shopping sites C. online banking sites D. private business sites (ch. 6) Which of the following statements about browser security settings is false? A. You can allow or block scripts on specific websites. B. You can accept or deny cookies. C. You must keep your accumulated web history as long as you use the browser. D. You can choose which sites run pop-ups. (ch. 6) With more and more people using technology, what physical health diagnosis is on the rise? A .cyberstalking B. repetitive strain injury C. cyberbullying D. technology addiction (ch. 6) What is a digital certificate? A. The key to unlock information into a readable format B. A growing trend used to combine multiple types of authentication C. The process of scrambling information so that it cannot be read D. Technology used to verify a user's identity (ch. 6) What would a password manager allow you to do? A. Create and store multiple strong passwords. B. Test your memorization skills. C. Prevent you from using birthdays in your passwords. D. Make sure you do not repeat passwords on similar accounts. (ch. 6) 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. A hacker is trying to put a Trojan on her computer. B. A worm has infected her computer and she needs to unplug her device. C. It is most likely ransomware because it is telling her she has to verify payment information to unlock her computer. D. 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. (ch. 6) What is it called when an attacker convinces you to enter personal information at an imposter website after receiving an email from a person masquerading as an employee from your bank? A. phishing B. dumpster diving C. identity theft D. encryption (ch. 6) How can you protect a computer from electrical spikes and surges? A. Use an uninterruptible power supply. B. Unplug the computer when it is not in use. C. Use a cable lock. D. Use a surge protector. (ch. 6) Which of the following forms of identity theft involves posing as a legitimate researcher to ask for personal information? A. research spoofing B. pretexting C. phishing D. cyberstalking (ch. 6) Emma downloaded a new game from an unfamiliar website. A few days later, Emma realized her system had been hacked and her credit card numbers were stolen. Without Emma knowing, what type of malware might she have downloaded to her computer? A. ransomware B. spam C. worm D. Trojan