CGS 2100 FINAL

Select the common video file formats.

- .mov - .avi

Select the image compression formats.

- JPEG - PNG

Blu-rays provide approximately ___ of storage space.

25 GB

According to YouTube, approximately how much video is uploaded to its site every minute?

300 hours

Most new cell phones today come with approximately ___ of RAM.

500MB - 2GB

CDs provide approximately ___ of data storage space.

700MB

DVDs store data using ___ .

A reflective coating that has pits and lands

CDs store data using ___ .

A reflective coating that has pits and lands.

In order to change sound waves into digital signals, smartphones contain ___ - digital converter.

Analog

Which optical drive media stores approximately 700 MBs of data?

CD

Emailing a file to yourself is an example of using ___ storage.

Cloud

Which category of management information systems (MIS) focuses on providing forecasting capabilities for sales and production?

DSS

Before you can start tethering, verify that it's included in your cell phone's ___ plan

Data

Collecting data, interpreting information gleaned from a database, and preparing reports for senior management are tasks that are typically assigned to a ___ .

Data analyst

Solid state drives store data using ___ .

Electronic circuits

A quick way to rename files or folders in Windows is to select the item and then press the ___ key.

F2

When you drag a file into the Recycle Bin it cannot be recovered.

False

The largest category of apps, both in terms of active downloads and in terms of revenue generated is ___ .

Game Apps

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ___ .

Hierarchy

Using refracted laser light to store data on a photoreceptive substrate is essentially how ___ storage works. Theoretically this could store gigabytes of data within a cubic millimeter

Holographic

When determining how much cell phone data you need it is important to consider

How much data you currently use.

Match the following cloud storage definitions to the correct terms.

IaaS: An organization uses serves in the cloud instead of buying and maintaining storage servers for their day-to-day business operations. PaaS: A programming environment used to develop, test and disseminate web apps via the internet. SaaS: The distribution of computer applications over the Internet. Commonly referred to as web apps.

Which of these browsers was developed by Microsoft?

Internet Explorer

The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.

Logical

Changing the appearance of your folder can make it easier to keep your information organized. To change your folder's appearance, first click on the folder, and then go to the command bar and click ___ .

Organize

Blu-ray stores data using ___ .

Pits and lands that are read by a blue spectrum laser beam

If you just need a phone for emergencies, you might consider a ___ phone.

Prepaid

Because of their capability of storing data in multiple hard drives, data warehouses use ___ technology to ensure redundant data storage.

RAID

In the data sheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .

Record

Software that gives network administrators the ability to provide computer assistance from a central location by allowing them to display and control any computer on the network is called ___ software.

Remote Desktop

To display or distribute information from a database, programmers or database administrators create ___ .

Reports

Because they have no mechanically moving parts, ___ provide extremely fast, efficient storage.

SSDs

In general, the ___ the access time, the faster the hard drive.

Shorter

A collection of related records in a database is referred to as a _____.

Table

The World Wide Web was created through a collaboration led by ___ .

Tim Berners-Lee

Errors in data occurring while entering, reading, processing, storing or transmitting is known as data ___.

corruption

Software that limits the material that a browser fetches or that a search engine displays are called ___ .

filters

A desktop computer's RAM is measured in __ of data.

gigabytes

Storage capacity for laptop hard drives is typically described in terabytes or ___ .

gigabytes

To allow hard disk drive platters to spin more smoothly and cooler, some manufacturers seal the platters in ___ instead of air.

helium

A short email uses about one ___ of data.

kilobyte

Because a metal platter is physically spinning, hard drives have ___ access times than solid state hard drives.

longer

One of the largest data requirements of the future will likely be ___ .

mapping patients' genomes

An electronic element that stores data by changing its resistance based on the current that has passed through it (similar to RRAM) is called a(n) ___ .

memristor

Server banks have capacities measured in ___ .

petabytes

If you accidentally delete a file it's not lost forever! Just go to your recycle bin, select the item, and click ___ .

restore

An easy way to rename a folder in Windows is to ___ -click on the folder and then click Rename.

right click

Sharing an Internet connection between two digital devices, for example, using your smartphone to create a hotspot and then using the hotspot to connect your laptop to the Internet, is referred to as ___ .

Tethering

T/F Your network's mobile switching station locates the MSS of the person you're calling, even if they use a different cell phone provider.

True

Match the capacity with the storage device

Typical laptop: 500GB-1TB Typical tablet: 16-256GB DVD: 3-5GB

Match the following regarding file compression:

Zip: a lossless compression format Lossy: reduces space required by removing less valuable data Lossless: Reduces space required by reducing redundancy within files.

Contact your ISP if your actual Internet speed is _____ than advertised.

slower

The component of a computer that allows data to be retained after power is turned off is referred to as _______.

storage

A thousand gigabytes equals one ___ .

terabyte

There are several ways to create a new folder in Windows. Which of these would work?

- Right-click a folder in the folders list. Click New and then click Folder - On the command bar, click New folder - Right-click any blank area in the Contents pane. Click New and then click Folder

Select the characteristics of cloud storage.

- users can download files to other devices on the internet - files are backed up (stored on multiple servers) - serves act like giant hard drives - lasers read the reflective substrate (coating) on the discs

Select the characteristics of a traditional hard drive.

- uses magnetically charged plates to store data - commonly found in desktop computers

In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something.

Field

An easy way to create a new folder in Windows is to ___ on any area in the Contents pane, and then click New and Folder.

right-click

Select the optical drives

- Blu-ray player - DVD drive

Select the common audio file formats.

- .mp3 - .mp4 (M4A) - .wav

Select the common word processing file extensions.

- .odf - .docx

Select what's true about database fields

- A group of related characters in a database - Represents a characteristic of someone or something - Primary key is a field designation

Which would be used to store a single bit of data?

- A transistor = A hole in a punch card - An email - A program

Your college has a database with a Students table. Which of the following could be a primary key in the table?

- Student number - Social Security Number

Select the usual tasks of information systems (IS) program managers.

- Supervising IS technicians - Working with developers and senior management to procure and implement IS processes - Developing training plans and policies for IS

Select the advantages of using a USB drive instead of a DVD.

- USB drive has shorter access time - USB drive is more durable

When you need to link 2 tables in a database that don't have a field in common, one solution is to create a _____ in one table that links to the primary key in the other table.

Foreign Key

Most desktop computers use ___ to store data.

Magnetic hard drives

Broadband is measured in _____ .

Mbps

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

If you wish to email a file to a friend, but find that it's too big for your email server, you can always ___ the file.

compress

A ___ name identifies a server site on the Internet.

domain

Select the reasons for compressing a file.

- Reduce the bandwidth needed to transmit a file - reduce storage space requirements

Select the advantages of using cloud storage.

- Redundancy: Data is stored on multiple servers - Availability: Data can be retrieved by any internet-connected device

Select the characteristics of a DVD.

- holds approximately 4.5 GB of data - uses pits and lands to store data

Select the characteristics of a CD.

- holds approximately 700 MB of data - uses pits and lands to store data

Select the methods of using cloud storage.

- saving a photo on Flickr - purchasing online storage space - emailing a file to yourself.

Which of the following file extensions is commonly used for term papers and other word processing tasks?

.docx

A smartphone emits approximately ___ watts of microwaves.

0-1

The text contained in about 4 books uses approximately ___ times more data than a short email.

1,000

Select the advantages of helium hard drives over traditional hard drives.

- Platter spin faster - platters stay cooler - more platters can be placed in the same amount of space

Check all the activities that would be considered uploading a file to the Internet.

- Posting a photo on social media. - Placing an ad on Craigslist - Posting a YouTube Video

To remove a file from one folder and place it in another, click on the item and press ___, then move your cursor to the new location and press CTRL + V.

CTRL + X

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data type

Because it allows their files to be accessed from any device on the Internet, many users like to back-up their files using ___ storage.

Cloud

If you have 2 folders open on your desktop and you want to move a file from one folder to the other, simply ___ the file.

drag

A URL identifies a particular __ address on the World Wide Web.

file

Select appropriate business email etiquette practices.

- Remember that potentially negative news is best given face to face - keep attachments small - Maintain high levels of formality, especially with initial contacts. - consider if email is the appropriate means of communication

Select the characteristics of computer storage.

- Retains data when power is turned off - sometimes referred to as secondary storage

Select the video file compression formats.

- AVI - MP4 - Quicktime

Select the cell phone manufacturers.

- Blackberry - Xiaomi -Huawei

Which of the following are considered storage media?

- DVDs - Blue-ray disks

Select the disadvantages of using cloud storage.

- Data stored on someone else's server can be accessed by anyone who has administrator privileges to the server - Data is only available if you're online

Select the characteristics of solid state drive storage devices.

- Durable, no moving mechanical parts - Uses electronic circuits to store data

Which of these should business owners do to help protect their data.

- Establish strong firewall protection for their business's network - Ensure antivirus software is installed and up-to-date - Create strong password protections and protocols

Choose the Samsung Galaxy tablet options.

- Note series - Tab series

There are several ways to rename a folder in Windows. Which of these would work?

- On the command bar, click Organize and then click Rename - Click the folder icon and press F2 to activate the edit mode. - Right-click a folder and click Rename

For which of the following activities would a typical marketing department need a strong information system?

- Online sales - Online advertising - Updating the business's social media sites

Select the storage devices

- Optical drive - External hard drive - USB drives