Prepare for your exams
Get points
Guidelines and tips

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips

Sell on Docsity

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents

20 Points

For each uploaded document

Answer questions

5 Points

For each given answer (max 1 per day)

All the ways to get free points

Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study

Go to the blog

ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+, Exams of Computer Applications

Reynolds Community College Computer Applications

ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+ | LATEST EXAM

Typology: Exams

2023/2024

Available from 02/29/2024

essay-writers 🇺🇸

3.8

(92)

1.9K documents

1 / 45

This page cannot be seen from the preview

Don't miss anything!

ITE 152 EXAM 3 ACTUAL EXAM 2024

| ALL QUESTIONS AND CORRECT

ANSWERS | ALREADY GRADED A+ |

LATEST EXAM

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?

-The table is missing a primary key.

-The table is sorted.

-The table is filtered.

-The table has been deleted. -----CORRECT ANSWER---------------The table is filtered.

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?

-Employer

-Graduated

-GPA

-Major -----CORRECT ANSWER---------------Graduated

One disadvantage of computerized databases is that they limit your ability to arrange

information.

-True

-False -----CORRECT ANSWER---------------False

A database is a collection of related information, but a database management system is

a type of software program.

-True

-False -----CORRECT ANSWER---------------True

A database is an organized collection of information.

-True

-False -----CORRECT ANSWER---------------True

Partial preview of the text

Download ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+ and more Exams Computer Applications in PDF only on Docsity!

ITE 152 EXAM 3 ACTUAL EXAM 2024

| ALL QUESTIONS AND CORRECT

ANSWERS | ALREADY GRADED A+ |

LATEST EXAM

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?

The table is missing a primary key.
The table is sorted.
The table is filtered.
The table has been deleted. -----CORRECT ANSWER---------------The table is filtered. 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?
Employer
Graduated
GPA
Major -----CORRECT ANSWER---------------Graduated One disadvantage of computerized databases is that they limit your ability to arrange information.
True
False -----CORRECT ANSWER---------------False A database is a collection of related information, but a database management system is a type of software program.
True
False -----CORRECT ANSWER---------------True A database is an organized collection of information.
True
False -----CORRECT ANSWER---------------True

What are the columns in a Microsoft Access table called?

Rows
Fields
Records
Columns -----CORRECT ANSWER---------------Fields 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?
Inventory
Employees
Customers
Vendors -----CORRECT ANSWER---------------Vendors What does SQL stand for?
Stated question language
Structured query language
System query lingo
Status query language -----CORRECT ANSWER---------------Structured query language Which of the following is LEAST likely to be a field in a Customers table?
LastName
Address
EmploymentDate
PhoneNumber -----CORRECT ANSWER---------------EmploymentDate A relationship is created between how many tables?
Two
Any number
Three
One -----CORRECT ANSWER---------------Two What is a query?
A question you ask a table

Queries in access can be used

Both 'a' and 'b'
Only 'a'
as a source of records for forms and reports
to view, change and analyze data in different ways -----CORRECT ANSWER--------------
Both 'a' and 'b' What does a filter do?
Make more records available
Hide records from view
Slow down processing
Add to the quantity of data -----CORRECT ANSWER---------------Hide records from view A field's data type determines what kind of information can be stored there.
True
False -----CORRECT ANSWER--------------- Which field could serve as the primary key for a list of students in your school?
Birth date
Phone number
Full name
Student ID number -----CORRECT ANSWER--------------- 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?
PageCount
Title
ProductID
Author -----CORRECT ANSWER---------------ProductID In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.
File
Field
Table
Record -----CORRECT ANSWER---------------Field

In a database, each _________________ contains a collection of related data.

Table
Field
Record
None of the above -----CORRECT ANSWER---------------Table Which of the following is a way to sort data?
Numerically
Alphabetically
All of the above
Chronologically -----CORRECT ANSWER---------------All of the above Contact information for all the people taking a class at a school are stored in a ________ called Students.
record
worksheet
field
table -----CORRECT ANSWER---------------Table 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?
Z to A
A to Z
Largest to smallest
Smallest to largest -----CORRECT ANSWER---------------Smallest to largest A query lets you speed up the browsing process by finding information that matches specifically to your criteria.
True
False -----CORRECT ANSWER---------------True Which data type would be best suited to a field that lists a product's clearance price?
Currency

To protect your information and help you to remember passwords, use your social media account login information to log into another site.

True
False -----CORRECT ANSWER---------------False After Penny broke up with her boyfriend, he texted some teammates from the track team about some private and intimate moments he and Penny had shared while they were dating. He even lied about their breakup, creating rumors about her behavior. Penny started getting inappropriate looks and advances from the team whenever she was at practice and felt completely humiliated. Penny is a victim of ________.
cyberbullying
cyberstalking
data mining
social engineering -----CORRECT ANSWER---------------Cyberbullying 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?
Ergonomics
Technology addiction
Repetitive strain
Cyberbullying -----CORRECT ANSWER---------------Ergonomics 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?
Two factor authentication
Digital certificates
Encryption
Biometrics -----CORRECT ANSWER---------------Biometrics With more and more people using technology, what physical health diagnosis is on the rise?
cyberbullying

cyberstalking
repetitive strain injury
technology addiction -----CORRECT ANSWER---------------Repetitive strain injury _____ ensures that the person requesting access to a computer is not an imposter.
Encryption
Authentication
Data mining
Automatic encoding -----CORRECT ANSWER---------------Authentication 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?
worm
ransomware
spam
Trojan -----CORRECT ANSWER---------------Trojan Siobhan has recently opened a Facebook account and as a new user, is posting frequently and accepting many friend requests. You see a post about an upcoming trip and notice that her profile is open to the public. What can you tell Siobhan to help her use social networking safely?
Allow anyone who "friends" her to view her information.
Post all types of photos more often.
Ignore notices from the social networking site about changes to security.
Be cautious about what information she posts. -----CORRECT ANSWER---------------Be cautious about what information she posts In which of the following situations is a digital certificate useful?
You are registering for an event.
You are emailing a friend.
You are signing a rental lease.
You are researching a topic for an assignment. -----CORRECT ANSWER--------------- You are signing a rental lease

If the browser security setting is from my favorite online retailers, I will accept it because the retailer knows what I like. - ----CORRECT ANSWER---------------I will need to review each browser security setting and use my best judgement. There are various risks from attacks on Wi-Fi networks. These include all of the following EXCEPT _____.
creating malware
downloading harmful content
viewing or stealing computer data
reading wireless transmissions -----CORRECT ANSWER---------------Creating malware In terms of privacy, which of the following is a best practice?
Saving your personal information as an email draft
Throwing away old bank statements that are more than three months old
Posting your location on social media
Keeping your Social Security number hidden in a locked box in your home ----- CORRECT ANSWER---------------Keeping your Social Security number hidden in a locked box in your home How does encryption work?
It scrambles the information until the key is used to unscramble it.
It is what happens when you download attachments from your email.
It protects data on your hard drive, but once you choose to send it to someone, it is no longer protected.
It is a key that you insert into your computer to unlock your saved files. -----CORRECT ANSWER---------------It scrambles the information until the key is used to unscramble it. How can you protect personal information gathered by legitimate organizations?
Use the same password and username for all your online accounts.
Create a separate email account for receiving information from websites.
Sign up for many online mailing lists.
Link your credit or debit card to your online accounts. -----CORRECT ANSWER---------- -----Create a separate email account for receiving information from websites. How is a worm different from a Trojan?

A worm prevents a device from functioning until a ransom is paid, whereas a Trojan gathers information and transmits it to another device.
A worm gathers information and transmits to a server, whereas a Trojan hides and then spreads through a network.
A worm reproduces itself on the same computer, whereas a Trojan attempts to spread through the network.
A worm spreads through a network, whereas a Trojan hides inside another program. --- --CORRECT ANSWER----------------A worm spreads through a network, whereas a Trojan hides inside another program. Your Facebook profile is private so there is no need to worry about your boss ever seeing your posts such as your Spring Break pictures.
True
False -----CORRECT ANSWER---------------False What type of security requires something you know and something you have that no one else has?
data mining
biometric security
two part passwords
two factor authentication -----CORRECT ANSWER---------------Two factor authentication What would a password manager allow you to do?
Test your memorization skills.
Make sure you do not repeat passwords on similar accounts.
Create and store multiple strong passwords.
Prevent you from using birthdays in your passwords. -----CORRECT ANSWER----------- ----Create and store multiple strong passwords. You can monitor and protect your financial data in all of the following ways EXCEPT _____.
Being cautious about what information you post on social networking sites.
Shredding financial documents before you discard them.
Querying unfamiliar purchases found on your bank statements.
Storing financial information in an unsent email message. -----CORRECT ANSWER----- ----------Storing financial information in an unsent email message.

Artificial learning
Unsupervised learning
Reinforcement learning -----CORRECT ANSWER---------------Unsupervised learning What technology allows Siri to understand you when you request a route to a location in a nearby city?
Artificial intelligence (AI)
Internet of Things (IoT)
Natural language processing (NLP)
Machine Learning (ML) -----CORRECT ANSWER---------------Natural language processing (NLP) Josh is concerned about protecting his home while he's away on vacation. He wants to leave a radio playing music so it sounds like someone is home. However, he wants the radio to turn on and off at different times so it appears that someone is interacting with it. What IoT device will allow Josh to turn the radio on and off using the Alexa app on his smartphone while he's traveling?
Smart bulb
Smart plug
Smart lock
Smart security system -----CORRECT ANSWER---------------Smart plug Terrance needs to set up a Windows server in his company's public cloud. What kind of cloud service will work best for this situation?
SaaS
IaaS
DBaaS
PaaS -----CORRECT ANSWER---------------IaaS Which cloud technology characteristic ensures that a cloud customer can make changes to her cloud database from her smartphone while traveling for a conference and from her laptop when she's at home?
Rapid elasticity
Resource pooling
Measured service
Broad network access -----CORRECT ANSWER---------------Broad network access

Frazer's mother recently experienced a stroke, and he needs to work from home for a while to help care for her. In what way will cloud computing most help Frazer in this situation?

He can make changes to his tax withholdings online.
He can complete on-the-job training customized to his job role.
He can remotely collaborate with teammates on projects, deadlines, and events.
He can back up data at data centers around the world. -----CORRECT ANSWER--------- ------He can remotely collaborate with teammates on projects, deadlines, and events. Business activities completed on a local, private network are examples of e-business even if cloud-hosted resources are not involved.
True
False -----CORRECT ANSWER---------------True Which company most likely relies almost solely on B2B transactions in their course of business?
Cleaning services company
Retail company
Shipping company
Chemical supply company -----CORRECT ANSWER---------------Chemical supply company Henry installed a smart thermostat to manage the temperature in his house. However, when Henry arrived home from work, the house was very cold. He's frustrated that this "smart" thermostat let the house get so cold. What does he need to provide the thermostat for it to do a better job in the future?
More information about his needs
More available settings for various temperatures
More installed smart devices to work together
More programming on how to interpret voice commands -----CORRECT ANSWER------ ---------More information about his needs Nancy runs her students' research papers through a plagiarism checker tool before grading them. What technology enables the plagiarism checker to keep improving its detection of poorly paraphrased text?
Machine learning (ML)
Natural language processing (NLP)

- B2C

- C2C

- B2B

- B2G -----CORRECT ANSWER---------------B2B

Rhea receives a text informing her that her credit card might have been compromised. The text asks her to confirm whether she made a purchase 15 minutes ago at a store that is over 2,000 miles away from her current location and that carries products she has never bought before. What technology was used to compare the purchase to Rhea's normal shopping habits and identify it as credit card fraud?

Natural language processing (NLP)
Robotic process automation
Data analytics
Chatbot -----CORRECT ANSWER---------------Data analytics Missy's retail website suddenly starts getting a lot of traffic and orders due to a video that went viral on social media. Her cloud-based servers scale up automatically to handle the increased demand. What cloud characteristic supports this automatic adjustment?
Measured service
Broad network access
On-demand self-service
Rapid elasticity -----CORRECT ANSWER---------------Rapid elasticity Which learning model allows an AI system to develop its own strategies for solving problems or completing tasks?
Unsupervised learning
Reinforcement learning
Supervised learning
Artificial learning -----CORRECT ANSWER---------------Reinforcement learning Who enforces PCI compliance for merchants who accept credit card payments from customers?
Cardholders
Merchants
Credit card companies
The Department of Defense -----CORRECT ANSWER---------------Credit card companies

Charlie's company makes custom-designed furniture. He purchases hardware for the furniture in bulk from a distributor in a nearby state. What kind of e-commerce platform does Charlie most likely use to order the hardware?

Physical storefront
Online storefront
Online marketplace
Social media -----CORRECT ANSWER---------------Online storefront Lionel works for a company that is trying to reduce travel time for their employees and allow more people to work from home. What kind of cloud service can Lionel use to attend meetings with his remote coworkers?
Desktop as a Service
Cloud storage
Video conferencing application
Cloud-hosted training modules -----CORRECT ANSWER---------------Video conferencing application Kason spends several hours a week generating reports on sick hours used across his company. The task eats up his available work hours and prevents him from doing other jobs he needs to do. What technology could take over this task and free up his time for more productive work?
Robotic process automation (RPA)
Internet of Things (IoT)-
Data analytics
Chatbot -----CORRECT ANSWER---------------Robotic process automation (RPA) How can you get the attention of a personal assistant app on your phone?
Say the wake word.
Complete the voice training process.
Reduce background noise.
Pause briefly before stating the command. -----CORRECT ANSWER---------------Say the wake word. Which of these e-commerce job roles could most likely be performed remotely from home or even from another country?

Play Journey.
Alexa, play Pandora music and include a lot of Journey songs.
Alexa, I like the Journey albums. Play some of those and make sure you use Pandora. -----CORRECT ANSWER---------------Alexa, play Journey songs on Pandora. Which field could serve as the primary key for a list of students in your school? ----- CORRECT ANSWER--------------Student ID number A field's data type determines what kind of information can be stored there. ----- CORRECT ANSWER--------------True 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? -----CORRECT ANSWER------------ --ProductID All the pet names in a veterinarian's database are stored in a _______ called PetName. -----CORRECT ANSWER--------------Field Which of the following is a way to sort data? -----CORRECT ANSWER--------------All of the above (Alphabetically, Numerically, Chronologically) What does SQL stand for? -----CORRECT ANSWER--------------Structured Query Language What is a query? -----CORRECT ANSWER--------------A question you ask a database What are the columns in a Microsoft Access table called? -----CORRECT ANSWER------ --------Fields

In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. -----CORRECT ANSWER--------------Field Which data type would be best suited to a field that lists a product's clearance price? ----

CORRECT ANSWER--------------Currency A query lets you speed up the browsing process by finding information that matches specifically to your criteria. -----CORRECT ANSWER--------------True What are the different views to display a table? -----CORRECT ANSWER--------------All of the above (Pivot Table & Pivot Chart View, Datasheet View, Design View) Databases typically store their data in one big table. -----CORRECT ANSWER-------------
False 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? -----CORRECT ANSWER--------- -----Smallest to largest In a database, each _________________ contains a collection of related data. ----- CORRECT ANSWER--------------Table (?) A database is an organized collection of information. -----CORRECT ANSWER------------ --True 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? ----- CORRECT ANSWER--------------Vendors

ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+, Exams of Computer Applications

Related documents

Partial preview of the text

Download ITE 152 EXAM 3 ACTUAL EXAM 2024 | ALL QUESTIONS AND CORRECT ANSWERS | ALREADY GRADED A+ and more Exams Computer Applications in PDF only on Docsity!

ITE 152 EXAM 3 ACTUAL EXAM 2024

| ALL QUESTIONS AND CORRECT

ANSWERS | ALREADY GRADED A+ |

LATEST EXAM

- B2C

- C2C

- B2B

- B2G -----CORRECT ANSWER---------------B2B