Chapter 13, 14

Question 1

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?

Answer 1

SQL

Question 2

Casey is looking for a free, open-source RDBMS for his company. Which of the following best meets these requirements?

Answer 2

PostgreSQL

Question 3

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?

Answer 3

Spreadsheet

Question 4

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

Answer 4

Customers, Ingredients

Question 5

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

Answer 5

Availability

Integrity

Question 6

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?

Answer 6

UPDATE

Question 7

Which of the following scenarios would most likely rely on Big Data? Choose two.

Answer 7

Evaluating applications for disability benefits.

Calculating traffic delays during rush hour.

Question 8

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

Answer 8

table

Question 9

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?

Answer 9

FROM Students

Question 10

Which of the following would most likely be the key paired with a value of “Canada” in a nonrelational customer database?

Answer 10

Country

Question 11

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?

Answer 11

ProductID

Question 12

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?

Answer 12

Nonrelational database

Question 13

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

Answer 13

Data warehouse

Question 14

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?

Answer 14

Open source

Question 15

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

Answer 15

veracity

Question 16

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?

Answer 16

Filter

Question 17

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?

Answer 17

Data analyst

Question 18

Which data type would be best suited to a field that lists customer email addresses?

Answer 18

Hyperlink

Question 19

Which of the following fields would be most important to encrypt in a customer table?

Answer 19

Customer’s credit card number

Question 20

What programming language supports relational databases?

Answer 20

SQL

Question 21

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?

Answer 21

Wikis can be heavily biased.

Question 22

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

Answer 22

Netiquette

Question 23

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?

Answer 23

Reset the old phone to factory settings.

Question 24

Which of the following is NOT a responsible way to dispose of an old smartphone after removing your data from the device?

Answer 24

Remove the battery and throw it in the trash.

Question 25

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

Answer 25

digital inclusion

Question 26

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

Answer 26

a hoax

Question 27

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?

Answer 27

Verify the content with an authoritative source.

Question 28

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?

Answer 28

People with color blindness

Question 29

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?

Answer 29

Acceptable use policy (AUP)

Question 30

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.

Answer 30

Switch to a standing desk.

Take frequent breaks.

Question 31

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

Answer 31

digital citizenship

Question 32

Curtis decided to leave his smartphone in his car as he heads out for a day long hike. This is an example of a ______________.

Answer 32

digital detox

Question 33

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

Answer 33

Cyberbullying

Question 34

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

Answer 34

catfishing

Question 35

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?

Answer 35

Digital rights management (DRM)

Question 36

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

Answer 36

digital footprint

Question 37

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?

Answer 37

Screen reader

Question 38

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

Answer 38

digital divide

Question 39

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.

Answer 39

the fair use doctrine

Question 40

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?

Answer 40

Repetitive strain injury