CGS 2060 Online: Final Exam
Where do you click to view the relationships between two tables?
Database tools
A database that stores data in different physical locations and that users access through client/server networks is called a ________ database.
Distributed
The roles of directing IS technicians, working with senior management to procure and implement IS, and developing policies for corporate IS typically falls to the ____________
Information systems (information technology) program manager
A row of information is called a _______
Record
The usual tasks of information systems (IS) security managers:
Responsible for keeping an organization's WiFi network secure. Creates and implements an organization's IS security measures.
The 2 most significant concerns regarding cloud storage are reliability and __________
Security
Which of the following can you do in Google chat?
Send a contact an image Send a message to a contact even when they're not online Send a colleague a hyperlink
Creating a WiFi hotspot with your cell phone is referred to as:
Tethering
To change the size of your desktop icons and folders, just right-click on a blank area of the contents pane and click ______
View
One of these extensions represents an executable file that is used to install programs onto your computer. Which one?
.exe
Common word processing file extensions:
.odt .docx
Ranks of most actively used apps:
1. Games 2. Business and Education 3.Lifestyle 4. Entertainment
Streaming video apps, such as Hulu or Netflix, can use as much as ______ of data per hour.
2.5 GB
If you just need a phone for calling and texting, a _______ phone can save you money.
3G
Advantages of using a database instead of a traditional filing system:
A database can provide improved data integrity A database can hold larger amounts of data
Database fields:
A group of related characters in a database table Represents a characteristic of someone or something.
Which would be used to store a single bit of data?
A hole in a punchcard A transistor
DVDs store data using:
A reflective coating that has pits and lands
What is required to send an instant message from a mobile device?
An internet conenction
What kind of Blu-ray disc can be recorded on multiple times?
BD-RE
Cell towers are connected to:
Base transceiver stations
When reporting a computer ethics violation of a coworker to your employer, its important to:
Be brief and direct State only what you witnessed
Smallest unit of storage:
Bit
This phone, the _______, was extremely popular in the early 2000s, and was known for its physical keyboard. It lost popularity after the release of the iPhone.
Blackberry
A __________ closes the access point used by the hacker.
Block
Storage media
Blu-ray disk CD DVD
Eight bits are considered to make one _____ of information.
Byte
If you have 2 folders open on your desktop and you want to copy a file from one folder to the other, hold down _____ and drag the file.
CTRL
Paste:
CTRL + V
Three important types of memory in your computer include registers, RAM, and ___________
Caches
Characteristics of a OneDrive account:
Can serve as extra storage space Provides free cloud storage Requires a Microsoft email account
Functions of a mobile switching station:
Changes the cell and base station your transmissions go through as you travel. Sends your call to the receivers MMS Assigns frequencies to your calls
If you have a gmail account, you automatically have a google ______ account which provides you with free cloud storage.
Drive
Business management software that encompasses nearly all business activities in a corporation is called _________ software.
ERP
Advantages of SSD storage:
Energy efficient Very fast
When referring to business information systems, ERP stands for ________ resource planning.
Enterprise
Executives rely on ____________ software because it provides tools to run an entire corporation.
Enterprise Resource Planning
If you see the extension .xlsx, you know you are looking at a(n) ________ file.
Excel
ESS stands for _______ support systems.
Executive
Storage device
External hard drive Optical drive Blu-ray player
To rename a file or folder, simply select the file and press which key?
F2
DVDs have pits and lands that absorb or reflect a ________ beam.
Laser
It's always a good idea to check the ________before clicking "Reply All"
List of addresses
Because it reduces an audio file's sampling rate to save space, the MP4 format is a _________ compression format.
Lossy
A large _________ can remove data from a traditional hard drive, but wont hurt a Blu-ray disk.
Magnet
Most desktop computers use _____________ to store data.
Magnetic hard drives
An electronic element that stores data by changing its resistance based on the current that has passed through it is called a _________
Memristor
A cell phone emits approximately 1 watt of _________
Microwaves
Because it locates cellular devices, assigns frequencies, transmits signals to the correct sites, the _______ is probably the most important part of any cellular network.
Mobile switching station
Advantages of helium hard drives over traditional hard drives
More platters can be placed in the same space, platters stay cooler, and platters spin faster.
Characteristics of SSDs:
No mechanically moving parts Use electronic circuits to store data
Which two methods take you to the Google (gmail) chat?
Open Google Hangouts and click on the chat area. Open gmail and click on the chat area
Image compression formats:
PNG JPEG
Server banks have capacities measured in ___________
Petabytes
Server banks have storage capacities measured in _______
Petabytes
When common fields link tables with relationships, this is called a ________ database.
Relational
A link between tables in a relational database that defines how the data is related is called a ________
Relationship
To display or distribute information from a database, programmers or database administrators create __________
Reports
If you accidentally delete a file it's not lost forever. Just go to your recycle bin, select the item, and click _________
Restore
Which category of management information systems (MIS) combines the forecasting capability of decision support software with the records keeping capability of transaction processing systems software to help businesses manage inventories efficiently?
SCMS
Because they have no mechanically moving parts, ________ provide extremely fast, efficient storage.
SSDs
A signal transmitted every few seconds by a wireless router so that user's computer can find identify the WiFi hotspot is called a(n) ________
SSID
The ________ the access time, the faster the hard drive.
Shorter
SSD stands for ______ State Drive
Solid
SCMS stands for ____ chain management software.
Supply
DBMS stands for Database Management ___________
System
Role of installing, maintaining, repairing, and replacing information hardware and software typically falls to the information systems ______
Technician
Along with the "From" line, what is the most important factor in ensuring your message is read?
The subject line
TPS stands for _______ processing systems.
Transaction
Creating a google drive takes ___ steps.
Two
Because they use flash-based tech, _____ drives provide fast, reliable, and energy efficient storage.
USB
USB stands for ______ serial bus.
Universal
Because of the popularity of and bandwidth and demands of video streaming, ______ data plans are more expensive than they were in the past?
Unlimited
When you're creating a voicemail greeting on your business phone, you should tell the caller:
When they can expect a return call If possible, why you can't take the call The voicemail that they've reached
Though not commercially successful, this phone was developed by one of the world's largest software developers.
Windows phone
Select the reasons why you might want to add a microSD card to your smartphone:
You want to save more image files You want to save more music files
Apple tablet offerings:
iPad Mini series iPad Pro series iPad Air series
Xcode and Swift are good programs to start with if you wish to create an app for the ________
iPhone
Large databases, often called data banks, that cover particular subjects are referred to as __________ databases.
Commercial
Characteristics of a traditional hard drive:
Commonly found in desktop computers Uses magnetically charged plates to store data
Having multiple users on the same cell is called __________ calling.
Conference
One way to move a file or folder to a new location is to right-click on the folder and select _____, then move to the new location, right-click and select paste.
Cut
Though it could theoretically hold terabytes of data for thousands of years in a microscopic space, ____ storage, using genetic material, is a distant storage option.
DNA
Which category of management information systems (MIS) focuses on providing forecasting capabilities for sales and production?
DSS
The optical media used most often to store movies are _______
DVDs
In a relational database, a common field that links two tables in a relationship but is not the primary key is called the _______ key.
Foreign
When you need to link 2 tables in a database that don't have a filed in common, one solution is to create a ____________ field in one table that links to the primary key in the other table.
Foreign key
To control how information is entered into a database, programmers and database administrators create ______ to ensure data integrity.
Forms
Which of these devices is manufactured by Samsung?
Galaxy Note
Characteristics of a DVD:
Holds approximately 4.5 GBs of data Uses pits and lands to store data
A refracted laser beam striking a photoreceptor from many different angles allows _________ storage technology to retain petabytes of data within 1 cubic inch of space.
Holographic
Using refracted laser light to store data on a photoreceptive substrate is essentially how __________ storage works.
Holographic
Network Intruder Detection Systems (IDS) often have areas known as "padded cells" or ___________, that are easy to hack into and are used to catch hackers.
Honeypots
An electronic element that stores data by changing its resistance based on the current that has passed through it is called a(n)
Memristor
To change your folder's appearance, first click on the folder, and then go to the command bar and click ______
Organize
Microsoft's email service has now transitioned to Microsoft ________
Outlook
In a relational database, an important field that contains a unique value that identifies each record as individual is the _______ key.
Primary
After your phone's analog-digital converter chip changes the sound of your voice to a digital signal, the signal is enhanced by a signal digital _______
Processor
So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of _________
Queries
To search a database for information, create a ________
Query