ITE 115 Exam 3

Which data type would be best suited to a field that lists customer email addresses? AutoNumber Date/Time Number Hyperlink

Hyperlink

What kind of database is needed to hold and organize diverse data types, such as X-ray images and doctors' notes, in a medical database? Relational database Big Data database Backup database Nonrelational database

Nonrelational database

Kiera is building a front-end user interface for the database her new website will use. Which of the following languages is NOT used to build a webpage? HTML JavaScript SQL CSS

SQL

Curtis decided to leave his smartphone in his car as he heads out for a day long hike. This is an example of a ______________. digital detox technology addiction digital footprint repetitive strain injury

digital detox

Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database? Name Product Affiliation Country

Country

Jason is reading a novel for school on his e-reader. He tries to print a portion of the novel so he can share it with a classmate who lost her copy. However, the e-reader will not allow the book to be printed. What content protection measure is preventing Jason from printing? Digital rights management (DRM) Public domain Copyright Fair use doctrine

Digital rights management (DRM)

Darcie has hired a programmer to make some custom changes to a DBMS she plans to move her business database to. What kind of DBMS is she using? Relational Proprietary DBaaS Open source

Open source

Which of the following fields would be most important to encrypt in a customer table? Customer's city Customer's sales representative Customer's status Customer's credit card number

Customer's credit card number

Raphael is working with a table in Access. He needs to see all the records for customers in Chattanooga so he can check the zip codes in that city. Which database tool will show only these records in the table? Filter Query Sort Report

Filter

Paige is designing a web page that will contain instructions for how to use a new web conferencing tool at her work. She formats best practice tips in green, and she formats warning information in red. Which employees might struggle with this formatting? People with visual impairments using screen magnifiers People reading the web page on their smartphones People with color blindness People with hearing impairments

People with color blindness

Bailey reads wikis at the beginning of his research project to get his bearings on the topic. He switches to peer-reviewed journals and professional publications for his formal sources. Why does Bailey not use wikis as formal sources? No one is familiar with wikis. Wikis can be heavily biased. Users cannot post false information in wikis. Experienced editors verify changes made to wiki articles.

Wikis can be heavily biased.

Kristy just received a laptop from her employer so she can work from home. She wonders if she can also use the laptop for personal activity, such as streaming movies. What documentation should Kristy check to find the answer to her question? Acceptable use policy (AUP) Knowledge base Code of conduct Warranty

Acceptable use policy (AUP)

Which of the following is a key aspect of database security according to the CIA triad security model? Choose two. Authorization Availability Integrity Identity

Availability and Integrity

Melody is building a database for a restaurant. Which pair of tables is least likely to need a direct relationship with each other? Customers, Orders Customers, Ingredients Products, Orders Products, Ingredients

Customers, Ingredients

Which of the following problematic behaviors relies solely on the use of digital technology? Harassment Cyberbullying Repetitive strain injuries Distracted driving

Cyberbullying

Morgan needs to hire someone to help implement a business intelligence system for her company. What type of professional would be the best fit for this job? Database administrator CEO Data analyst Retailer

Data analyst

Which data repository type is most likely to include database tables and primary keys in its internal data structure? Data lake Data dashboard Data warehouse Data mart

Data warehouse

Which of the following scenarios would most likely rely on Big Data? Choose two. Evaluating applications for disability benefits Calculating a student's course average Calculating traffic delays during rush hour Budgeting for a home renovation

Evaluating applications for disability benefits and Calculating traffic delays during rush hour

Mindy needs to run a SQL query that will pull the names and birthdates of all her students. What should the FROM phrase say in her query? FROM Students FROM Birthdate FROM Name FROM Schools

FROM Students

What rules should guide your behavior when you interact with friends and coworkers on social media? Netiquette Code of conduct Acceptable use policy (AUP) Digital inclusion

Netiquette

Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements? Microsoft SQL Server PostgreSQL MongoDB Oracle Database

PostgreSQL

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 PageCount Title ProductID

ProductID

Which of the following is NOT a responsible way to dispose of an old smartphone after removing your data from the device? Donate it to a charity. Remove the battery and throw it in the trash. Trade it for credit at a technology store. Take it to a recycling facility.

Remove the battery and throw it in the trash.

Genevieve loves playing video games with friends on her Xbox connected to her TV. However, she's careful to get up, stretch, and walk around at least once every hour. What problem is this habit most likely helping her avoid? Text neck Technology addiction Accidental falls Repetitive strain injury

Repetitive strain injury

Laney just bought a new smartphone. She's already downloaded her contacts information and other data from the cloud. Now she's copying her photos from her old phone onto the new device. Once her new phone has all her data, what should she do next with the old phone? Reset the old phone to factory settings. Donate the old phone to a nonprofit organization for refurbishing. Throw away the old phone. Create a backup of all data on the old phone.

Reset the old phone to factory settings.

What programming language supports relational databases? HTML NoSQL SQL CSS

SQL

Hunter has dyslexia and struggles to understand text when he reads it to himself. It seems assigned class readings always make more sense when someone else reads them to him. What tool can help Hunter study more independently? Alternative keyboard Screen reader Alt text Screen magnifier

Screen reader

Scarlet needs to create a file to hold a list of expenses for an upcoming project, and she needs to do some basic calculations with the numbers in the budget. Which kind of file is the best fit for this purpose? Spreadsheet Presentation Database Document

Spreadsheet

Alvaro is having lower back pain from working long hours on his computer. Which of the following strategies could help him solve this problem? Choose two. Don't text and walk. Switch to a standing desk. Take frequent breaks. Use speech-to-text technology.

Switch to a standing desk. Take frequent breaks.

One of Eden's customers has closed his account and moved to a different state. She needs to change his status to Inactive. What SQL command will accomplish this task? DELETE INSERT SELECT UPDATE

UPDATE

Edward shares a blog post on social media that says the Centers for Disease Control (CDC) has changed their recommendation for flu shots. He is quickly bombarded by other people saying his information is wrong. What did Edward fail to do? Check the blog post for bad grammar. Post an opposing point of view to maintain balance. Check the blog post for accessibility features, such as alt text. Verify the content with an authoritative source.

Verify the content with an authoritative source.

Marley stayed up late to watch the planet Mars rise in the east. She had read online that Mars was unusually close to the Earth in its orbit and would look nearly as large as the moon. However, she only saw stars, and the next morning she ended up oversleeping because of her late bedtime. Marley was the victim of __________. distracted driving a data breach a hoax the digital divide

a hoax

Francis closely monitors customer reviews on Google for his landscaping business. Most customers post high praise for his work; however, today he discovered an extremely negative review posted by someone claiming the name "Superman." Clearly, this is a fake name, and Francis has no way of following up with the person to determine what he can do to resolve the problem or even to know if it's a real customer. This is an example of __________. software piracy spamming plagiarism catfishing

catfishing

Bruce realizes he's getting a cramp in his neck after texting with his buddy for several minutes. He puts the phone down and takes his dog for a walk. This is an example of ____________. digital literacy digital etiquette digital security digital citizenship

digital citizenship

Josie is scrolling through her social media newsfeed when she sees a photo of her that a friend posted. The photo is embarrassing and was taken without Josie's knowledge when she was staying at the friend's house. Josie requests the photo be taken down. Josie is managing her own ___________. public domain digital footprint data breach netiquette

digital footprint

Brad donates his old phone to a nearby charity, which refurbishes phones and offers them at no cost to challenged populations in the area. These people can use the free phones to help them find housing, employment, and other community resources. This program supports ______________. digital inclusion the Internet of Things (IoT) an acceptable use policy (AUP) the digital divide

digital inclusion

Contact information for all the people taking a class at a school are stored in a ________ called Students. field record worksheet table

table

During a regional state of emergency, an Internet service provider offered three months of free Internet access to anyone affected by the crisis. This effort was intended to help reduce the impact of ___________. digital inclusion data breaches the digital divide digital access

the digital divide

When Hafsa writes a research paper for her psychology class, ________________ allow(s) her to quote small portions of a research study published by an industry leading expert without asking his permission first. copyright digital rights management (DRM) intellectual property rights the fair use doctrine

the fair use doctrine

What characteristic of Big Data indicates how closely that data matches reality? velocity veracity volume variety

veracity