Computer Fundamentals Course Exam
What search operator would you use with the word "Android" to find Android phone, Android smartphone, and Android cell phone?
* (asterisk)
Which type of a computer can be assembled using a monitor, a keyboard, a CPU, speakers, a printer and a mouse?
A desktop computer
Which type of website would allow Evan, an avid traveler, to share photos and videos with his friends?
A social networking website
Computer-aided design software helps architects, engineers, and scientists to design, analyze, and manufacture products with the precision of human-level intelligence. Which of the following technologies does CAD incorporate to achieve this?
Artificial intelligence and machine learning
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?
Be cautious about what information she posts.
Which of the following statements is true about the Clipboard?
Because he is using the same name, each time he saves he is overwriting his previous work.
The news reports a security breach of credit card information at a large department store that has recently laid off many employees. Why should the store investigate the possibility of the breach being from an insider?
Because insiders sometimes create threats after incidents at their places of employment
Which of these is an optical medium of storage?
Blu-ray disc
Which network protocol allows devices to communicate with each other over a short range, usually less than 30 feet/9 meters?
Bluetooth
What determines the speed at which data travels?
Bus width
Raina is putting finishing touches on her Ph.D. thesis report. She feels she should emphasize the keywords throughout the thesis. How can she do this in the word processor she is using?
Change font size, style, and color of the keywords.
Pierre has entered marks obtained by the students in all the classes he teaches in a spreadsheet. Now he wants to highlight some data according to his specifications. Which spreadsheet feature should he use?
Conditional formatting
Ronald maintains a website that focuses on travel-related information. He gathers adventure posts from various travel blogs and shares them to his site. What type of a website does Ronald maintain?
Content aggregator site
Which of the following would most likely be the key paired with a value of "Canada" in a nonrelational customer database?
Country
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
If you want to use evidence found on computers, networks, and other devices to help solve crimes, then which of the following careers is a match for you?
Digital forensics
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)
Norma is a graphic designer creating a logo that will be resized often. Which of the following file formats should she choose to create the logo?
EPS
As chief financial officer, you want to send the fourth quarter profit/loss spreadsheets to the president of the company. How can you send the report without worrying about someone else accessing it?
Encrypt the data in the report.
Before you can open and edit a compressed file, you need to zip it.
False
Everything you do online is recorded in the cloud, but you can choose to erase it, as you have control over your digital footprint.
False
Haven runs an online bridal store called Haven Bridals. Her website is encrypted and uses a digital certificate. The website address for the store is http://www.havenbridals.com.
False
Operating systems can run only if they are installed on a hard drive.
False
Social-networking sites have a history of providing tight security and giving users a clear understanding of how security features work.
False
To prevent a laptop from being stolen, you can use a surge protector.
False
Twitter is an example of a wiki, which allows for collaborative editing by its users.
False
What is the correct sequence of processing instructions in a machine cycle?
Fetch à decode à execute à store
Which of the following is an authentication method to keep your data safe?
Fingerprint scanner
Tameka is expecting a baby and her partner wants to make sure he can get her to the hospital on the day of delivery using the fastest route possible regardless of time of day. How should he decide which technology to use?
He should choose a navigation app with artificial intelligence that can provide information about preferred routes.
Which data type would be best suited to a field that lists customer email addresses?
Hyperlink
How will you decide which browser security settings to allow and which ones to block?
I will need to review each browser security setting and use my best judgement.
A bitmap image is provided in two different resolutions. Image 1 has a resolution of 1500 x 1225. Image 2 has a resolution of 500 x 350. Which of the following statements is true when the sizes of both the files are increased by 25 percent?
Image 1 is sharper and has a larger file size than image 2.
In a large business, the _____ Department makes sure that all the computer operations, mobile devices, and networks run smoothly.
Information Technology
_____ is data and instructions entered into the memory of a device.
Input
Alex received an email from what appeared to be his bank. What would indicate the message was actually a phishing attempt?
It contained typos and other grammatical errors.
LensForAll is a company that sells affordable contact lenses on its website. The CEO of the company realizes that an app must be developed that would allow customers to virtually try on colored lenses to find out what best suits them. Which of these features should the app have?
It should have responsive design so that it is easy to use on mobile devices.
How would you describe an intelligent workplace?
It uses technology to enable workers to connect and communicate.
What should you do the first time you save a file?
Name the file.
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?
Nonrelational database
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
Daniel wants to buy a computer to use for playing games after work. He loves racing games and wants to make sure his device has all the specifications needed to run them smoothly and efficiently. Which of these factors should he consider?
Processor core - some applications, especially games, have greater processor requirements
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?
ProductID
When it comes to secure data storage on a network, which of the following statements is true?
Roles can be granted to individuals to view files and make changes to files on a network.
What hardware is essential to creating a home Wi-Fi network?
Router
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
In business, what has replaced social bookmarking in helping users find the most relevant, high-quality information, collect it, and share it with others?
Social curation sites
What is it called when someone attempts to befriend you online for the purpose of stealing confidential or sensitive information?
Social engineering
What technology can be used by people with a hearing disability to listen to a narration?
Speech recognition
What performance specification does 2 GHz refer to?
Speed at which the processor executes instructions
Search engines use software that combs the web to find webpages and add new data about them to the database. What is this software called?
Spiders
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.
Take frequent breaks. Switch to a standing desk.
Which of the following is a step in the email communication process?
The message travels along Internet routers to the recipient.
How does a wireless network key work with an encrypted wireless network?
The sending and receiving devices must know the wireless network key to communicate.
How might a business use a blog?
To communicate with customers
To resolve major computer issues, computer professionals often suggest restoring the operating system. Which of the following should happen before this step?
Transfer contents to an external storage device.
A specialty search engine lets you search online information sources that general search engines do not always access.
True
An intelligent workplace uses technology to enable workers to connect to the company's network, communicate with each other, use productivity software and apps, and meet via web conferencing.
True
Digital audio can be created by recording sound on a smartphone.
True
Embedded computers usually are small and have limited hardware but enhance the capabilities of everyday devices.
True
Output methods include speakers, headphones, and interactive whiteboards.
True
Peripheral devices, like a USB flash drive, are generally connected to your computer through ports.
True
The Unicode coding scheme supports a variety of characters including those for Chinese, Japanese, and Arabic languages.
True
Wikipedia is a collaborative website where a team of people can publish or modify content on a webpage.
True
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
How is an executable file different from a data file?
Unlike a data file, you cannot open and read executable files.
How is streaming a video different from downloading it?
Unlike streamed content, downloaded content is stored on the computer.
How can you protect a computer from electrical spikes and surges?
Use a surge protector.
Which of the following is a necessary step in maintaining computer hardware?
Using a UPS or a surge processor
Logan is considering web app development as a career option. Which of the following languages does he not need to master?
Visual Basic
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.
Rafael has to type a report about a class trip to the museum. Which of the following apps should he use to write the report?
Word processor
How would you describe the social networking site YouTube?
YouTube is a media-sharing network.
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
If you want to remove an older email from your inbox, but not permanently delete it, you can _____ it.
archive
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
Sean works for an organization that offers SaaS to a chain of boutiques. By getting data from the database, he has to prepare a list of instances when the billing transaction failed. Which of the following tasks does he need to do to prepare the report?
database
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
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
Kareem wants to include line drawings of abstract shapes on his personal website. What should he use to acquire the graphics?
drawing software
Posting hostile or insulting comments in response to someone else's blog post is called _____.
flaming
If you have a file that has billions of bytes of data, then it would be measured in _____.
gigabytes
Manny copied a table from an MS Excel file, closed the file, and then pasted the table in an MS Word document. Where was the table stored after he copied it?
in RAM
A network administrator is usually not required on a _____ network.
peer-to-peer
When considering a computer to purchase, which of the following factors involves the operating system of the computer?
platform
Which of the following forms of identity theft involves posing as a legitimate researcher to ask for personal information?
pretexting
A smart refrigerator can use _____ to detect when you are running low on milk, and then send a reminder to you on a wireless network.
sensors
On what type of network can you rent things such as cars, tools, and rooms?
sharing economy network
Which of the following types of websites typically provides the least security?
social media sites
What type of hard drive has no moving parts, making it fast and durable?
solid state drive
Fiona is responsible for presenting data at the monthly team meeting so that it can be understood at a glance and is visually appealing way. The data is available in spreadsheet. Which of the following can Fiona do?
sparklines
Akira has a mobility impairment that makes it difficult to type on a keyboard. What technology can she use to create written documents without using a keyboard?
speech recognition software
You need a(n) _____ to play an MP3 audio file on a desktop or laptop computer.
stand-alone player
Jack needs a convenient way to browse the Internet, read emails, and store basic data when he travels. Which of the following would be the best option for him?
tablet
The bootstrap program executes which of the following?
tests that check components such as RAM and storage
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
Why do companies use online collaborative productivity software?
to allow employees to share, edit, and comment on documents
Which of the following is assigned to each webpage to identify its location on the Internet?
uniform resource locator (URL)
What characteristic of Big Data indicates how closely that data matches reality?
veracity
When Alice turned on her laptop this morning, the screen displayed only colorful horizontal lines. Which of the following is most likely to have a problem?
video card
Margot and Tomas have heard how beautiful the Swiss Alps are, but they are afraid to fly. What technology could they use to see and experience the Alps without flying there?
virtual reality (VR)
