NEW
Font size
S
M
L
XL
WorksheetsCCAS FINAL EXAM REVIEW
Total questions: 52
Worksheet time: 26mins
Name
Class
Date
1.
___________ is “detonated” when a specific event occurs—for example, all personnel records are erased when an electronic notation is made that a particular person was fired.
a)
A linked lineage
b)
An employee ejection
c)
A time bomb
d)
A logic bomb
2.
A ________ attack disables a computer system or network by making so many requests of it that it overloads it and keeps other users from accessing it.
a)
worm
b)
virus
c)
Trojan horse
d)
denial-of-service
3.
Also known as white-hat hackers, _______ hackers are ethical hackers are usually computer professionals who break into computer systems and networks with the knowledge of their owners to expose security flaws that can then be fixed.
a)
benign
b)
benevolent
c)
cyberterrorists
d)
hacktivists
4.
What is the science, often used in computer security systems, of measuring individual body characteristics?
a)
encryption
b)
biometrics
c)
artificial intelligence
d)
rootkit
5.
What is the process of altering readable data (plain text) into unreadable form to prevent unauthorized access?
a)
password sealing
b)
decryption
c)
password
d)
encryption
6.
Encryption is the process of ______________.
a)
downloading a secret software program in a computer's operating system.
b)
using multiple techniques to attack a computers system.
c)
altering readable data into an unreadable form to prevent unauthorized access.
d)
removing pieces of hardware.
7.
__________ hackers are computer professionals who break into computer systems and networks with the knowledge of their owners to expose security flaws that can then be fixed.
a)
Malignant
b)
Black-hat
c)
Cracker
d)
Benevolent
8.
Signals represented by two states (binary) are said to be _______. Signals such as sound, light and temperature, which continuously vary in strength and quality, are said to be _________.
a)
digital; analog
b)
analog;digital
c)
narrowband; broadband
d)
intranet; extranet
9.
_____________ is short range wireless digital standard aimed at linking cell phones, computers, and peripherals up to distances of about 33 feet.
a)
GPS
b)
Fiberoptics
c)
Bluetooth
d)
Ethernet
10.
_______ TV uses a digital signal, or series of 0s and 1s, and is much clearer and less prone to interference than analog TV.
a)
Standard-definition
b)
Advanced
c)
interactive
d)
High-definition (HD)
11.
A digital camera's resolution is expressed in ________.
a)
micropixels
b)
DPI
c)
megapixels
d)
megabits
12.
Digital convergence combines several industries, including:
a)
computers and communications
b)
consumer electronics
c)
entertainment and mass media
d)
all of these
13.
________ involves the recording of Internet radio or similar Internet programs. It requires no studio or broadcast tower and is not regulated by the FCC (Federal Communications Commission).
a)
Podcasting
b)
Radio sharing
c)
Audio beaming
d)
Aggregaming
14.
A digital TV's width-to-height ratio is called the __________________.
a)
aspect ratio
b)
sampling line
c)
top line number
d)
DTV signal
15.
Which is NOT a societal effect of digital TV?
a)
Quantity shifting: Reducing the amount of TV watched
b)
Time shifting: Changing when you watch TV
c)
Space shifting: Changing where you watch TV
d)
Content shifting: Changing the nature of TV programs
16.
On the web, the creative combination of content or elements from different sources to create new content is called a _________.
a)
sampling
b)
PMP
c)
mashup
d)
convergence
17.
A _____________is a logically organized collection of related data designed and built for a specific purpose, a technology for pulling together facts that allows the slicing and dicing and mixing and matching of unprocessed data in all kinds of ways and turning it into useful information.
a)
management system
b)
data dictionary
c)
database
d)
info system
18.
In general all information to support intelligent decision making within an organization must be:
a)
correct and verifiable.
b)
accessible.
c)
current.
d)
all of these choices
19.
Information flows between departments within organizations. The __________ department would be responsible for managing their computer based systems and plans for purchasing new ones.
a)
accounting and finance
b)
information systems
c)
operations
d)
human resources
20.
_____________ is designed to determine whether a computer possesses "intelligence" or "self-awareness". In it a person talks with two entities behind a computer terminal and has to judge which one is the computer and which one is a human.
a)
The Gunther test
b)
The Singularity test
c)
The Turing test
d)
The Self Awareness test
21.
The "singularity" refers to _______________
a)
the point of technological advancement at which we will have only one type of computer.
b)
a moment when humans would have created self-aware, smarter-than-human machines that are capable of designing computers and robots that are better than humans can make today.
c)
software that identifies unique patterns in what it is seeing and summarizes that into a single best code that is universally compatible with AI systems both weak AND strong.
d)
the culmination of Big Data to a single AI body of mass DSS databases with expert knowledge capabilities.
22.
Which of the following is the computer-assisted process of sifting through and analyzing vast amounts of data to extract meaning and discover new knowledge?
a)
data mining
b)
e-commerce
c)
data warehousing
d)
business-to-business systems
23.
A field is a unit of data consisting of one or more ________.
a)
tables
b)
records
c)
bits
d)
characters
24.
What is the correct order of the data storage hierarchy?
a)
Bits, Characters (bytes), Fields (columns), Records (rows), and Files (tables).
b)
Bits, Fields (columns), Records (rows), Files (tables), Characters, Sheets
c)
Records (rows), Files (tables), Characters, Bits, Fields (columns)
d)
Bytes, Fields (columns), Bits, Characters, and Records (rows)
25.
________is "cleansed" data about data; it shows the origin of the data, the transformations it has undergone, and summary information about it.
a)
AI
b)
Database drivers
c)
Metadata
d)
Miniaturized data
26.
A ___________ is a field (or fields) in a record that holds unique data that identifies that record from all the other records in the table and in the database.
a)
key field (primary key)
b)
secondary key
c)
meta file
d)
hierarchy
27.
___________________________ is a type of challenge–response test used in computing to determine whether the user is human.
a)
CAPTCHA
b)
TURING test
c)
Vector check
d)
Computational check-point
28.
A ____________ is a unit of data consisting of one or more characters. Examples are your first name or your student ID.
a)
field
b)
record
c)
byte
d)
table
29.
A ____________ is a collection of related records. An example is a stored listing of everyone employed in the same department of a company including names, addresses, and Social Security numbers.
a)
file (table)
b)
record
c)
byte
d)
database
30.
________can be added to a tab to help guide the reader’s eyes across the page.
a)
Leaders
b)
Tabs
c)
Rulers
d)
Indents
31.
________________ font means letters and characters that have different widths. In contrast, ______________ refers to font that contains letters and characters that each occupy the same amount of space between letter.
a)
proportional, monospaced
b)
serif, sans serif
c)
monospaced, proportional
d)
sans serif, serif
32.
This term refers to a lightened image or text that displays behind text on a page.
a)
faint label
b)
watermark
c)
clearmark
d)
pagemark
33.
The keyboard shortcut to reveal the Formatting pane is ______. The keyboard shortcut to enter a page break is ______.
a)
Shift + Enter and Ctrl+ X
b)
Ctrl + F1 and Shift+ V
c)
Shift + F1 and Ctrl+ Enter
d)
Shift + F and Ctrl+ PB
34.
Which of the following is not one of Word’s default settings?
a)
right and left margins of one inch
b)
portrait page orientation
c)
page size of 8.5 inches by 11 inches
d)
two column page layout
35.
What does the Format painter button do?
a)
changes the color of the font
b)
applies predefined formatting to the entire document
c)
turns highlighting on or off
d)
copies formatting from one part of the document to another part
36.
You can add tabs at the Tabs dialog box or with this feature that is at the top of your display screen.
a)
ruler
b)
tab view
c)
gridline
d)
tab setter line
37.
In MS Office Applications the _______ toolbar contains buttons specifically for commonly used commands.
a)
Home
b)
QuickAccess
c)
Start
d)
File
38.
The ________ is the area in Microsoft Office application screens which contains tabs and commands divided into groups.
a)
guidebar
b)
ribbon
c)
desktop
d)
office toolbar
39.
You realized you made an error while creating your document. You used the word “maroon” instead of “burgundy” in several places. What is the quickest way for you to correct your mistake?
a)
Use the Cut and Paste feature.
b)
Use the Copy and Paste feature.
c)
Click Ignore in the Spell Check and retype them manually.
d)
Use the Find and Replace feature.
40.
A cell reference that reflects the row or column to which it has been copied is called a(n) ________ cell reference. On the other hand a(n)______________ reference keeps a row and/or column constant.
a)
fixed, variable
b)
relative, absolute
c)
dynamic, static
d)
absolute, relative
41.
The IF function returns one of two values based on a _______.
a)
fallacy error
b)
logical test
c)
true or false validation
d)
check of functions
42.
The _____________ is a useful tool that can save lots of time by copying formulas rather than having to type them in each time.
a)
fill handle
b)
format painter
c)
autosum
d)
handlebar
43.
____________is a feature in Microsoft Excel that automatically adjusts the width or height of a cell.
a)
Freefit
b)
Easyfit
c)
Sumfit
d)
Autofit
44.
When creating a database which object is created first?
a)
form
b)
report
c)
table
d)
query
45.
Which piece of data would be most appropriate to use as a primary key for students in a college?
a)
Last name
b)
Birthday
c)
Dorm address
d)
Student ID
46.
This is the term for the black line that displays between the common field name in the two field list boxes after a relationship has been created.
a)
relationship mark
b)
link connection
c)
join line
d)
infinity lock
47.
Let's say we created a form for customers to enter their addresses. Now we're having trouble organizing the records because some customers type the complete state name, while others type only the abbreviation. How could we prevent this from happening?
a)
Create a totals row.
b)
Insert sort criteria.
c)
Create a validation rule.
d)
Run a query.
48.
What's the fastest way to find all of the customers in our database who have not yet paid for their orders?
a)
Look it up in a form
b)
Search a table
c)
Delete a record
d)
Run a query
49.
In Access, the rows and columns of a table are referred to as __________________.
a)
Filters and categories
b)
Placeholders and categories
c)
Rows and columns
d)
Records and fields
50.
Where can you find a list of every object in a database?
a)
Ribbon
b)
Document Tabs bar
c)
Help menu
d)
Navigation page
51.
Why would you want to create a report?
a)
Reports are used to add data collection fields to forms.
b)
Reports allow you to export a table as an Excel file.
c)
Reports make it easy to add records to a table.
d)
Reports allow you to present tables and query results in an easy-to-read format.
52.
Which is a valid data type in Access?
a)
Number
b)
Text
c)
Currency
d)
All of the choices
Reset
