Font size
WorksheetsITSA EOY Review - Part 2
Total questions: 40
Worksheet time: 41mins
For a standalone application, everything is housed in a single computer.
True
False
Which of the following is NOT part of Data Definition?
Permissions - Grant / Revoke
Create
Alter
Delete
Which of the following is NOT a basic computing operation?
Input
Process
Storage
Output
Feedback
Match the following
Database
Lots of data, unlimited user access
Flat File
Minimal data, limited user access
Data Definition
Defines table - fields / columns
Data Manipulation
Manipulates records / rows
____________ is a threat to confidentiality. (select 2)
DDOS
DOS
Shoulder surfing
Dumpster diving
_________ software allows a developer to modify original code and distribute their own version.
Spyware
Open source
Commercial
Subscription
What does a Kilobyte measure?
Processor speed
Power
Throughput
Storage
What does a Gigahertz measure?
Processor speed
Power
Throughput
Storage
Match the following
OEM
The company that manufactures products
Printer Driver
Install if printer not recognized
RAM
Short-term memory
ROM
Keeps data permanently on a chip
Power Supply
Converts power to correct format
Which of the following does NOT describe SSD?
stores data even when powered off
has no moving parts
temporary storage of data
smaller, faster than hard disk drives
Which of the following best defines confidentiality in context with information and data?
The ability to limit access to information to a certain set of users
The certainty that information is accurate
The confirmation that a company will not sell your information to others
The reliability of access to information
Which of the following is defined as "information arranged in horizontal rows and vertical columns"?
Themes
Template
Table
exit effect
Match the following
Wiretapping
secretly monitor a conversation
UPS
Helps with power sags
DOS
a computer becomes unavailable
DDOS
flooded server, network not available
Replay attack
attacker reuses data captured in transit
What are the programs that instruct computers to perform specific operations?
cookies
software
hardware
information systems
Match the following
Server
Secure it before allowing connections
USB Flash Drive
Stores, backups & transfers files
Adobe Reader
Used to make PDF documents
Optical Drive
Used to view training videos
Match the following
char
one symbol, digit or letter
variable
can store numbers that change
boolean
true or false
if
can select options based on user choice
constant
stores data that does not change
Which of the following are advantages of installing an application to the cloud? (select all that apply)
safeguards against damage from fire
Internet access is not required
supports data replication
safeguards against a natural disaster
Which of the following describe SSD? (select all that apply)
has no moving parts
offers persistent data storage
could store music or video files
is non-volatile, relatively durable
Match the following
What you know
password or PIN #
Who you are
retina scan or fingerprint
Where you are
turn on location or live video feed
What you have
smart card or ID card
Match the following
Bluetooth connection
wirelessly connect peripherals, <=30 ft
Symmetric Key
one key to encrypt & decrypt
binary
notational system, "on" or "off"
Java is compiled
can run as a locally installed file
SQL - Structured Query Language
for database creation & manipulation
Match the following
Drop
To get rid of a table
Delete
To remove a record or row
Grant Permissions
Part of Data Definition
Primary Key
Uniquely identifies a database record
Select
Can get results from a time range
Which of the following describe a Type 1 Hypervisor? (select all that apply)
sometimes called a bare metal system
interacts directly with hardware
manages storage
manages network
manages virtual machines
Match the following
Inkjet Printer
Uses cartridge to spray drops of ink
Encryption
can protect data on a stolen laptop
Compression
Modifying data to reduce its size
Virtual Meeting Software
Online meetings, beyond video chat alone
Project Management Tools
Assists teams in managing projects
Match the following troubleshooting methodology steps
first step
identify the problem
second step
research knowledge base
third step
establish theory of probably cause
fourth step
test the theory of probable cause
fifth step
establish a plan of action
Match the following trouble-shooting methodology steps
sixth step
implement the solution or escalate
seventh step
verify full system functionality
eighth step
document the solution & the cause
Match the following
Watermark
faint design, prevents duplication
Copyright
example - game features instructions
Trademark
protects logos and slogans
Patent
protects inventions
Which of the following describes Data Reports? (select all that apply)
could have graphical format
it is the same as Data Backup
would most likely use a CSV file
organizes useful information
Match the following
MITM - Man in the Middle
Integrity concern
Power outage
Availability concern
Eavesdropping
Confidentiality concern
Which of the following could assist a help desk technician in finding out if other users encountered the same issue? (check all that apply)
implement or escalate
question users
document the findings
test the theory
Match the following
Firewall
allows or blocks network traffic
Full Disk Encryption
encodes data using an encrypted key
Process
application running on a typical OS
Windows Defender
built-in anti-virus & anti-malware
Patch
updates or repairs data
Match the following relational database constructs
Column
data listed vertically, known as a field
Constraint
controls data that can be entered
Schema
defines how data is organized
Records
horizontal data structure, known as rows
Which of the following does NOT describe EMI (Electromagnetic Interference)?
it is used for cellular service in remote locations
can cause wireless connection issues
fluorescent lights can decrease broadcast signal
removing sources of EMI can increase wireless connection
A technician browses to the same site a user had an issue with. Why did the technician do that?
to establish a plan of action
to escalate the issue
to document the findings
to duplicate the problem
Match the following
to minimize the impact of a disaster
establish a disaster recovery plan
to prevent security breaches in a network
install a proxy firewall
to improve system performance
enable disk defragmentation
a previously working printer stops working
ensure both devices connect to LAN
Match the following SQL commands
to fetch or retrieve data
select
to remove records in a table
delete
to remove all information from a database
drop
to change the data of records in a table
update
Match the following
Typing user credentials with a keyboard
is an example of Data Input
Wireless Access Point allows wireless devices
to communicate on a wired network
A Server has a role on a LAN &
distributes services to group of clients
Foreign Key refers to a
unique identifier in separate table
What is an application?
A computer program that does something useful (or fun!).
A request to do something.
A set of steps for performing a task, like a recipe.
A group of programming statements.
