Font size
WorksheetsCS Study Guide ALL
Total questions: 74
Worksheet time: 1hrs 14mins
Given the numerical value 1010101.11, which of the following number systems is MOST likely represented?
Decimal
Hexadecimal
Binary
Octal
Anetwork host has an IPv4 address of 192.168.12.155. Which of the following notational systems is used to
represent this IP address?
Decimal
Octal
Binary
Hexadecimal
A programmer is creating an application that needs to store a value indicating if the user is logged in or not.
Which of the following would be the BEST data type to accomplish this?
String
Float
Integer
Boolean
Mark wants to include a string in his computer program that lets users know they have selected the correct option.
He wants to include the option in double quotes. However, the entire string also needs to be delimited by double
quotes.
Which of the following is the string Mark should use to include the option in double quotes?
\"Congratulations! "Launch Audit" is the correct option.\"
"Congratulations! \"Launch Audit\" is the correct option. "
"\Congratulations! "Launch Audit" is the correct option.\"
"\Congratulations! "Launch Audit" is the con•ect option.\"
Which of the following does a computer use to make sure that people, hardware, and software can interface with
each other?
OS (operating system)
Device driver
Application and hardware interface
GUI (graphical user interface)
Which of the following are examples of input devices? (Select two.)
Projectors
Monitors
Touch Screens
Keyboards
Speakers
Which of the following are features of using an Excel table to store data? (Select two.)
Data correlation
Graphing
Total row
Range
Column sorting
Firewalls, data encryption, backups, and passwords are designed to protect computing devices. These
technologies are all examples of what?
File compression
Data protection
Secure transactions
D.
Security controls
How many bits are in a single byte?
four
eight
twelve
sixteen
A consumer wants to add a hard drive to their computer to store video from their camera. Which of the
following is the storage capacity of a modern hard disk drive (HDD) purchased from a computer store?
3 terabytes
4 gigabytes
1,024 kilobytes
8 megabytes
Which of the following is the first thing you should do in the troubleshooting process when trying to identify
possible causes of a problem?
Check with others to see if they can duplicate the problem.
Test your theories to verify the cause of the problem.
Check for obvious or common issues.
Divide and conquer to find a possible cause.
You are troubleshooting a malfunctioning notebook computer. Nothing appears on the LED display when the system is powered on.
Which of the following is the BEST step to try first?
Replace the motherboard
Plug in an external monitor
Calibrate the battery
Replace the video card
Which of the following connectors are used to terminate a Cat 5e and Cat 6a network cable?
RJ-11
LC
BNC
RJ-45
Rick and Steve want to share information between their smart phones without connecting to the WiFi network.
Which of the following is the least complicated way to accomplish this?
NFC
Infrared
Bluetooth
USB cable
You are replacing your graphics card and have uninstalled the driver using the software package. You want to verify that the device is fully uninstalled. Which of the following would be the BEST place to verify the
graphics card has been fully uninstalled?
Control Panel
Add/Remove Programs
Device Manager
Settings
You are troubleshooting a client's issue. Whenever she tries to double-click on a folder, the folder highlights but does not open. Your client gets frustrated because she has to keep clicking until the folder finally opens.
Which of the following should you do to correct this issue?
Tell the user to click the mouse buttons faster.
Select a slower double-click speed in Mouse Properties.
Select a faster double-click speed in Mouse Properties.
Tell the user to click the mouse buttons slower.
Which of the following BEST describes a motherboard?
A chip that controls all other parts of a computer by getting information from them and then telling
them what to do
A printed circuit board that contains sockets and slots for upgradeable components
A chip that makes sure all necessary parts are plugged in and working properly on bootup so that
the operating system can start loading
A unit that supplies electricity to computer components
Which of the following components converts AC to DC?
Surge protector
Voltage regulator
Capacitor
Power supply
Which network type uses light pulses to transmit data?
Fiber optic
Cable
Satellite
Wireless
Which medium does Wi-Fi use to send data between networks and devices?
Bluetooth
Cellular signals
Radio waves
Ultraviolet light
Which of the following is NOT a long-term storage device?
Flash drive
Hard disk
RAM
Compact disc
What do the light and dark spots on an optical disc represent?
1s and 0s
Write speed
Type of disc
Read speed
Which of the following provides services to hosts on its network?
Email
Server
Client
Storage
When processing and networking functionality is integrated into everyday objects, like refrigerators, vacuums, and even clothing, what is it called?
Drone
IOT (Internet of Things)
Automation
Robot
A computer system can be interconnected to other computer systems for the purpose of sharing information with each other. What are these computer systems called?
Network servers
Network interfaces
Network clients
Local area networks (LANs)
Which of the following internet protocols makes sure that data packets are assembled on the receiving end in the correct order so that a complete data package is delivered?
Domain Name System (DNS)
Internet Protocol (IP)
Transmission Control Protocol (TCP)
HyperText Transfer Protocol (HTTP)
Frank, a technician, has finished installing a wireless router. Jessica is connected to the Wi-Fi. However, she can only see the company intranet pages. What should Frank do to troubleshoot the problem?
Apply a firmware update
Clear the browser cache.
Configure the browser proxy settings.
Disable the pop-up blocker.
Brandon, a technician, has recently noticed that the wireless network in the office has slowed down. What could he do to support faster connections?
A. Upgrade to 802.11g
Enable Wi-Fi Protected Access
Reduce any possible EMI
Change the default password
Which of the following is used on a wireless network to identify the network name?
SSID
WPA2 passphrase
WEP key
MAC address
Which kind of system software is preinstalled on electronic products like blenders, automobiles, and televisions?
Utility Software
Firmware
Device Drivers
Operating System
Which category of system software provides a platform for application software to run on?
Device Drivers
Firm-ware
Utility Software
Operating System
Tom has a 7-gigabyte file he wants to put on a 16-gigabyte flash drive. To be able place this large file on the
flash drive, what must Tom do to this flash drive first?
Format the flash drive to FAT16.
Re-partition the flash drive.
Format the flash drive to NTFS.
Format the flash drive to FAT32.
Ben wants to format his flash drive so it can be read on many types of devices, such as game consoles and
different desktop computers running different operating systems. Which file system should he format his flash drive to, so it can be used this way?
FAT32
NTFS
Ext4
exFAT
Clickable text or images that take you to different sites on the World Wide Web are called
Shortcuts
Hyperlink
Attachments
Navigation buttons
Which of the following are web browsers? (Select two.)
Google Chrome
Microsoft Visio
Mozilla Firefox
Bing
Which of the following runs exclusively form the cloud, relying on cloud technologies? (Select Two)
Microsoft Word
Adobe Acrobat Reader
Dropbox
Google Drive
Adobe Photoshop
Which installation method is most likely to put your computer at risk of downloading a virus?
App store installation
Software subscription
Internet installation
CD or DVD installation
Katy has uninstalled a photo editing application, but an icon still appears on her web browser for the application.
Which of the following is the BEST solution for getting rid of the icon?
Re-install and then uninstall the application.
Disable the application add-on in the web browser.
Remove the application add-on in the web browser.
Clear browsing data and launch a new instance of the browser.
You are vacationing at a friend's cabin on the lake and using the office computer to complete some work-related
tasks using a web browser. The browser keeps slowing down after a few minutes of use. You check for extensions
(add-ons) and notice that there are several listed.
Knowing that extensions can slow down a browser, what should you do to speed up the web browser processing
time?
Uninstall several of the extensions.
Uninstall the web browser and re-install it.
Disable several of the extensions.
Remove several of the extensions.
What is software that is delivered over the Internet through a web browser called?
Temporary software
Shareable software
Online-only software
Web applications
Your organization has 20 employees who need an accounting software update installed. Due to a
miscommunication, the purchaser only paid to update 10 licenses. The software company issued a paper license
and a single key for updating 10 users. This is an enterprise paper license and there is no mechanism that
enforces a limit to the number of times the key can be used. You decide to update all 20 users.
Which of the following are possible consequences of this decision? (Select two.)
The software company will never detect the violation so negative consequences are unlikely.
There are no consequences. By law, you are allowed 1 to 3 activations per user.
The software will eventually stop working properly for the 10 extra updates you installed.
Your company is exposed to litigation by violating the software license agreement.
You risk losing your job.
A developer wants to take existing code written by another person and add some features specific to their needs.
Which of the following software licensing models allows them to make changes and publish their own version?
Software-as-a-Service (SaaS)
Proprietary
Subscription
Open-source
Lisa is a software developer and needs to create a complied executable program for one of her clients. Which of the following is a compiled programming language she could use? (Select two.)
Java
C#
PHP
Perl
SQL
A business user wants to retrieve data from a relational database. Which of the following would they use to get the data they need?
Markup language
Compiled language
Query language
Interpreted language
Lynda, a programmer, is developing a Linux device driver in assembly language. Many device drivers are written in the C language. Which of the following is the BEST reason for using assembly language instead of C?
Code written in assembly is more efficient and allows direct access to hardware.
Assembly code is more portable than C.
Code written in assembly is easier to read than compiled C code.
Assembly code is more detailed and doesn't use libraries.
Computer programming is ________________
Operating a machine with computerized components, such as a smartphone.
Using advanced computer applications like Excel or Access.
Giving a computer precise instruction for what it should do
An application that can run on a computer.
Jessica, a programmer, has created specific statements, including conditional loops to accomplish a task. What has she created?
Software
Algorithm
Pseudocode
Flowchart
A programmer wants to create a visual representation of all the branching and sequencing for a program. Which of the following should the programmer use?
Pseudocode
Algorithm
Flow chart
Function
Lydia, a programmer, is using a two-dimensional array to store a user's status for their chat program. As a
container, an array is a special kind of variable that can store many values. Lydia created the following:
declare user (40,2) as a string
Which of the following is true about containers?
A container is an identifier that is used to reference the user array.
A container is not relevant to this array example.
A container is only used to declare arrays.
A container cannot be used for string vectors.
After lunning the following pseudocode, what will the value of VARIABLE be?
Set value of VARIABLE to 5.
Increase the value of VARIABLE by 3
If the value of VARIABLE is odd, increase its value by 1
If the value of VARIABLE is even, increase the value by 1
If the value of VARIABLE is odd, increase its value by 1
8
9
10
11
What is the result of the following pseudocode when the value of currentDistance is 6?
declare hike 12
if currentDistance < hike
display "Keep going, you can do it!"
else if currentDistance >= hike
display "Great job, you made it!"
end
Nothing. The comparison is never true.
Great job, you made it!
Keep going, you can do it!
Syntax error
Which database object is essentially questions that we can ask the database?
Tables
Forms
Reports
Queries
Which of the following database objects provides a summary of data?
Queries
Forms
Tables
Reports
Which of the following scenarios is an example of why an application or utility would need a database for
persistent data storage?
A student creates and saves a graphic image.
A customer fills out an online fonn to order a Bluetooth speaker.
A system manager edits and saves a network device's configuration.
A business manager edits and saves a PowerPoint presentation.
A NOT NULL____________is a rule that prevents certain fields in a database from being left blank.
Schema
query builder
constraint
scalability
Which of the following BEST describes the permissions a user has for a database object after creating the object while logged into their user account?
The objectfs creator has all pemmissions for the object, except those limited by the DENY command.
The object's creator is limited to permissions given by the GRANT command.
The objects creator can deny permissions to the object for other user account
The object's creator has complete control over that object.
What group of database commands is used to define and modify metadata?
Data definition
Data control
Data correlation
Data manipulation
Mark is a database administrator who's responsible for managing the records in a boat inventory relational
database for a local chain of boat shops. Recently, the owners have decided to expand to several more stores. Mark has hired David, an assistant administrator, to help out.
In order to get staited, he wants to grant permission to the assistant to retrieve and view information in the
database. Which of the following SQL commands can Mark use to grant this permission to David?
GRANT ALL ON boat inventory TO David
GRANT UPDATE ON boat inventory TO David
GRANT SELECT TO david ON boat inventory
GRANT SELECT ON boat inventory TO david
Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database?
SELECT
GRANT
CREATE VIEW
RETRIEVE
Which kind of online attack involves pretending to be a legitimate company to get sensitive information?
Virus
Phishing
Spyware
Impersonating
What is the best countermeasure against social engineering?
Acceptable use policy
User awareness training
Strong passwords
Access auditing
Anna, a user, downloaded a free pdf editing application from the internet. Now the laptop constantly displays desktop popups and several applications won't start.
Anna was the victim of which of the following?
Trojan horse
Social engineering
Worm
Spyware
A user is unable to read their computer files. A pop-up explains that the files have been encrypted and gives
instructions on how to purchase a decryption key. Which of the following BEST describes this malware?
Trojan horse
Ransomware
Spyware
Social engineering
Why is it better to use a credit card than a debit card for online purchases?
Credit cards have better interest rates
Credit cards keep track of all your transactions
Credit cards have better fraud protection
Debit cards require you to pay additional fees
Unwanted, unsolicited emails containing advertisements, political rhetoric, hoaxes, or scams are collectively
known as_______
Spam
Illegal messages
Bloatware
Cookies
Which of the following security measures is a form of biometrics?
Chassis intrusion detection
BIOS password
Fingerprint scanner
TPM
Which of the following components of a successful access control framework is the process of proving that you are who you say you are?
Authentication
Access control
Accounting
Authorization
An IT department discovered that the users were not periodically changing their passwords. Which of the
following password policies should they require of their users?
Password complexity
Password length
Password age
Password reuse policy
The password policy below incolporates the following:
• Passwords must include at least one capital letter
• Passwords must include a mix of letters and numbers
• Passwords must be different from the past eight passwords
• Passwords must contain at least one non-alphanumeric character
Which of the following password best practices are being used? (Select two).
Password age
Password history
Password complexity
Password lockout
Password length
A user has opened a web browser and accessed a website where they are creating an account. The registration page is asking the user for their username (email address) and a password. The user looks at the URL and the protocol being used is HTTP. Which of the following describes how the data will be transmitted from the webpage to the webserver?
AES encrypted message
Cipher text
Plain text
WPA2 encryption
Which of the following do the sender and the receiver of encrypted text use to decipher and read information?
Advanced Encryption Standard (AES)
Key
Secure code
HTTPS
What is the surest way to prevent the loss of important information on your mobile device if it is lost, stolen, destroyed, or there is a natural disaster?
Configure your device to remotely backup important data to the Cloud.
Don't put important information on your mobile device.
Only use apps, such as email apps, that store data on the app provider's servers.
Configure your device to backup important data to your personal computer.
You have configured your Windows systems to automatically backup user data every night at midnight. You also take a system image backup once a month.
In addition, which of the following would MOST likely ensure that you are protected against data loss? (Select Two).
Configure System Maintenance to automatically defragment system hard drives every night.
Write-protect all backup media.
Store a copy of all backups off-site.
Restrict restoration privileges to system administrators.
Regularly test restoration procedures.
Christopher is surfing the web and sees an amazing offer for a product he's interested in. He clicks the link and begins the process of purchasing the item. While he is proceeding with the purchase, he notices that the address bar is a maroon color.
Should he proceed with putting in private information and purchasing the item from this site?
No, the maroon color indicates an invalid certificate.
No, he needs to create a user account first.
Yes, maroon means a pending certificate.
Yes, maroon is a trusted certificate.
