Deck 10: Exam

Question 1

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) distracted driving
B) a data breach
C) a hoax
D) the digital divide

Answer 1

C

Question 2

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.

A) Don't text and walk.
B) Switch to a standing desk.
C) Take frequent breaks.
D) Use speech-to-text technology.

Answer 2

B, C

Question 3

A person who does not own a laptop or smartphone is not a digital citizen and so does not need to be concerned about digital ethics.

Answer 3

False

Question 4

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?

A) Digital rights management (DRM)
B) Public domain
C) Copyright
D) Fair use doctrine

Question 5

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?

A) Check the blog post for bad grammar.
B) Post an opposing point of view to maintain balance.
C) Check the blog post for accessibility features, such as alt text.
D) Verify the content with an authoritative source.

Question 6

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

A) digital inclusion
B) the Internet of Things (IoT)
C) an acceptable use policy (AUP)
D) the digital divide

Question 7

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

A) software piracy
B) spamming
C) plagiarism
D) catfishing

Question 8

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?

A) Acceptable use policy (AUP)
B) Knowledge base
C) Code of conduct
D) Warranty

Question 9

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?

A) Alternative keyboard
B) Screen reader
C) Alt text
D) Screen magnifier

Question 10

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?

A) People with visual impairments using screen magnifiers
B) People reading the web page on their smartphones
C) People with color blindness
D) People with hearing impairments

Question 11

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

A) Harassment
B) Cyberbullying
C) Repetitive strain injuries
D) Distracted driving

Question 12

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

A) public domain
B) digital footprint
C) data breach
D) netiquette

Question 13

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

A) digital inclusion
B) data breaches
C) the digital divide
D) digital access

Question 14

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?

A) No one is familiar with wikis.
B) Wikis can be heavily biased.
C) Users can post false information in wikis.
D) Experienced editors verify changes made to wiki articles.

Question 15

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

A) digital detox
B) technology addiction
C) digital footprint
D) repetitive strain injury

Question 16

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

A) Netiquette
B) Code of conduct
C) Acceptable use policy (AUP)
D) Digital inclusion

Question 17

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

A) digital literacy
B) digital etiquette
C) digital security
D) digital citizenship

Question 18

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?

A) Text neck
B) Technology addiction
C) Accidental falls
D) Repetitive strain injury

Question 19

Maisie doesn't limit her time watching enjoyable and relaxing shows on her laptop in the evenings after work and on the weekends because technology has an entirely wholesome effect without any risks.

Question 20

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.

A) copyright
B) digital rights management (DRM)
C) intellectual property rights
D) the fair use doctrine

Question 21

Sami is trying to figure out why she keeps missing deadlines for her schoolwork.She enjoys playing video games during her downtime, but she doesn't think this relaxing hobby interferes with her grades.And yet, she's still losing points from missed work.How can Sami determine what effect technology has on her schoolwork?

A) Give up gaming for a few weeks and see if that helps.
B) Keep a log of all her gaming activities.
C) Take occasional breaks while gaming.
D) Keep a log of all her technology use.

Question 22

Which of the following factors might indicate that content on the Internet is reliable?

A) The author cites resources from respected authorities.
B) The author is urging action that would financially benefit that author.
C) The author is affiliated with an organization that is committed to one side of the issue.
D) The author is biased toward one perspective.

Question 23

A child who grows up without regular access to computers and the Internet will be at a disadvantage later due to the ___________.

A) data breach
B) digital divide
C) smart devices
D) digital inclusion

Question 24

Maria is writing a fictional story about a character with a nickname that is copied from a very popular book series.The nickname affectionately refers to personality features of this character that are similar to the character in the other book series.Maria is concerned about whether she might be sued for using this nickname in her own book.Who should she contact to find out if she is allowed to use the nickname in this way?

A) Her writing teacher
B) An elected official in her local government
C) An attorney
D) The U.S.Copyright Office

Question 25

Ricky unplugs his Amazon Alexa smart speaker when he's not using it.He's trying to limit unnecessary ____________.

A) digital inclusion
B) data collection
C) cyberbullying
D) data breaches

Question 26

What guiding principle typically discourages people from arguing with strangers on social media?

A) Digital footprint
B) Current law
C) Technology limitations
D) Netiquette

Question 27

A behavior that is legal is also ethical and moral.

Question 28

A country's lawmakers define __________ standards of conduct.

A) moral
B) legal
C) personal
D) ethical

Question 29

Alfred is applying for his first full-time job after finishing his college degree.Which of the following activities during his school years has left a negative digital footprint for his potential employers to find?

A) Good spelling and grammar
B) Profanity on social media posts
C) Photos of his latest family vacation
D) Blog posts about developments within his industry

Question 30

Phillip works long hours from home on his computer.While the work is challenging, he loves it and feels energized by the long, productive hours.Lately, however, he's been having trouble falling asleep.What strategy will help him get to sleep more easily?

A) Keep a log of his activity with technology.
B) Do more relaxing activities with technology.
C) Take a break from devices throughout the day.
D) Do a digital detox about an hour before bedtime.

Question 31

Knowing how to change text formatting on a resume document in Word is an example of ___________.

A) digital citizenship
B) social networking
C) social etiquette
D) digital literacy

Question 32

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

A) Donate it to a charity.
B) Remove the battery and throw it in the trash.
C) Trade it for credit at a technology store.
D) Take it to a recycling facility.

Question 33

Digital ethics define clear right and wrong answers to dilemmas faced by technology users.

Question 34

Leif is designing a website for his employer.Which of the following elements on the home page will NOT require alt text?

A) The company logo
B) A photo of the team members
C) The page title
D) A graphical icon

Question 35

What kind of software can help a web developer check her online content for accessibility issues?

A) Browser
B) Screen magnifier
C) Content management system
D) Screen reader

Question 36

Content published on the Internet tends to be reliable.

Question 37

Which of the following is NOT potentially a direct consequence of violating copyright?

A) A driver could get a speeding ticket.
B) An employee could get fired from their job.
C) A student could be expelled from school.
D) A person could be sentenced to jail.

Question 38

Knowing how to communicate respectfully on social media is an example of ____________.

A) digital literacy
B) plagiarism
C) cyberbullying
D) digital citizenship

Question 39

Which of these tasks can NOT be replaced with a technology-based option?

A) Handwriting notes in class
B) Asking for directions to a restaurant
C) Walking the dog
D) Paying for books at a store

Question 40

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?

A) Reset the old phone to factory settings.
B) Donate the old phone to a nonprofit organization for refurbishing.
C) Throw away the old phone.
D) Create a backup of all data on the old phone.

Question 41

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

A) Customers, Orders
B) Customers, Ingredients
C) Products, Orders
D) Products, Ingredients

Question 42

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

A) Microsoft SQL Server
B) PostgreSQL
C) MongoDB
D) Oracle Database

Question 43

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?

A) Filter
B) Query
C) Sort
D) Report

Question 44

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?

A) HTML
B) JavaScript
C) SQL
D) CSS

Question 45

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?

A) FROM Students
B) FROM Birthdate
C) FROM Name
D) FROM Schools

Question 46

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

A) field
B) record
C) worksheet
D) table

Question 47

After you've backed up your data to your new phone, how can you securely delete the data from your old phone before donating it to a charity for reuse?

A) Reset the device to its factory settings.
B) Delete each file off the old phone, one by one.
C) Dispose of the old battery.
D) Back up the old phone to the cloud.

Question 48

Jenson needs to update his home address in his health insurance company's database.Which of the following applications can he open on his computer so he can make these changes?

A) A browser
B) A spreadsheet application
C) An RDBMS
D) A DBMS

Question 49

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

A) AutoNumber
B) Date/Time
C) Number
D) Hyperlink

Question 50

Aron is building a website that will require a back-end database.He plans to connect the web server on his network in a way that it will be easily accessible from the Internet.He should connect his database server the same way so data in the database is readily accessible to the web server.

Question 51

What programming language supports relational databases?

A) HTML
B) NoSQL
C) SQL
D) CSS

Question 52

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?

A) Spreadsheet
B) Presentation
C) Database
D) Document

Question 53

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?

A) DELETE
B) INSERT
C) SELECT
D) UPDATE

Question 54

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) A to Z
B) Smallest to largest
C) Z to A
D) Largest to smallest

Question 55

River often feels anxious during class when he can't check his phone for new text messages or emails.This problem is an example of _______________.

A) technology addiction
B) digital detox
C) eye strain
D) text neck

Question 56

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

A) Customer's city
B) Customer's sales representative
C) Customer's status
D) Customer's credit card number

Question 57

Which of the following behaviors most likely causes eye strain?

A) Texting and walking at the same time
B) Spending too much time looking at devices
C) Standing up while working at a desk
D) Having poor posture when using devices

Question 58

If an organization accepts old technological devices for recycling or refurbishing, you can be assured that the device is being handled responsibly.

Question 59

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?

A) Relational
B) Proprietary
C) DBaaS
D) Open source

Question 60

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) Author
B) PageCount
C) Title
D) ProductID

Question 61

Which of the following is LEAST likely to be a field in a Customers table?

A) EmploymentDate
B) PhoneNumber
C) LastName
D) Address

Question 62

All the pet names in a veterinarian's database are stored in a _______ called PetName.

A) table
B) record
C) field
D) worksheet

Question 63

Which data type would be best suited to a field that lists a product's clearance price?

A) AutoNumber
B) Date/Time
C) Currency
D) Number

Question 64

Which of these file types is optimized for processing calculations of numbers in a budget?

A) Database
B) Presentation
C) Document
D) Spreadsheet

Question 65

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

Question 66

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) Employer
C) Graduated
D) GPA

Question 67

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

A) Authorization
B) Availability
C) Integrity
D) Identity

Question 68

Which of these tasks is a non-technical user most likely to have the right to perform in a database?

A) Delete a record.
B) Add new data.
C) Name a field in a table.
D) Create a relationship between two tables.

Question 69

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

A) Name
B) Product
C) Affiliation
D) Country

Question 70

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) Customers
B) Inventory
C) Vendors
D) Employees

Question 71

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

A) velocity
B) veracity
C) volume
D) variety

Question 72

Which of the following is NOT an RDBMS?

A) MySQL
B) PostgreSQL
C) Microsoft SQL Server
D) Oracle NoSQL Database

Question 73

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?

A) Relational database
B) Big Data database
C) Backup database
D) Nonrelational database

Question 74

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

A) Evaluating applications for disability benefits
B) Calculating a student's course average
C) Calculating traffic delays during rush hour
D) Budgeting for a home renovation

Question 75

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 sorted.
B) The table is missing a primary key.
C) The table has been deleted.
D) The table is filtered.

Question 76

A database backup can include information on who made what changes and when since the previous database backup.

Question 77

Students who complete an online test are not allowed to change their test grades.What aspect of the CIA triad is at work here?

A) Availability
B) Integrity
C) Scalability
D) Confidentiality

Question 78

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?

A) Database administrator
B) CEO
C) Data analyst
D) Retailer

Question 79

Open source DBMSs are insecure because users are allowed to see the software's code.

Question 80

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

A) Data lake
B) Data dashboard
C) Data warehouse
D) Data mart