ITE EXAM 3

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

4.Hyperlink

Which of the following problematic behaviors relies on the use of digital technology?

Cyberbullying

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

What rules should guide your behavior when you interact with friends and coworkers on social media?

Netiquette

What programming language supports relational databases?

SQL

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?

UPDATE

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?

Wikis can be heavily biased

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 divide

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

1. Evaluating applications for disability benefits 3. Calculating traffic delays during rush hour

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

2. Availability 3. Integrity

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

2. Customers, Ingredients

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? 1. Check the blog post for bad grammar. 2. Post an opposing point of view to maintain balance. 3. Check the blog post for accessibility features, such as alt text. 4. Verify the content with an authoritative source.

4. Verify the content with an authoritative source.

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)

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?

Data Analyst

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 Citizenship

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)

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

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

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?

Open Source

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 color blindness

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?

Repetitive strain injury

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?

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

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 __________.

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 __________.

catfishing

Which data repository type is most likely to include database tables and primary keys in its internal data structure?

data warehouse

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 ___________.

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

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.

the fair use doctrine

What characteristic of Big Data indicates how closely that data matches reality?

veracity

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

2. PostgreSQL

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

2. Remove the battery and throw it in the trash

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. 1. Don't text and walk. 2. Switch to a standing desk. 3. Take frequent breaks. 4. Use speech-to-text technology.

2. Switch to a standing desk. 3. Take frequent breaks.

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? 1. HTML 2. JavaScript 3. SQL 4. CSS

3. SQL

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

4. Country

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

4. Customer's credit card number

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? 1. Relational database 2. Big Data database 3. Backup database 4. Nonrelational database

4. Nonrelational database

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? 1. Author 2. PageCount 3. Title 4. ProductID

4. ProductID

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.

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

table