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