CGS 2100 FINAL

Select the common video file formats.

1. .mov 2. .avi 3. .MPEG

Select the common audio file formats.

1. .mp3 2. .mp4 (M4A) 3. .wav

Select the advantages of using a database instead of a traditional filing system.

1. A database can hold larger amounts of data. 2. A database can provide better data integrity.

Select what's true about database fields.

1. A group of related characters in a database 2. Represents a characteristic of someone or something 3. Primary key is a field designation

Select the video file compression formats.

1. AVI 2. MP4 3. QuickTime

Select two optical drives.

1. DVD drive 2. Blu-ray player

Which two of the following are considered storage media?

1. DVDs 2. Blu-ray discs

Select two disadvantages of using cloud storage.

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

Select two characteristics of solid state drive storage devices.

1. Durable, no moving mechanical parts 2. Uses electronic circuits to store data

What are two commonly used names for USB drives?

1. Flash drives 2. Thumb drives

Match each of the options above to the items below.

1. Graphics Interchange Format (GIF): Legacy (outdated) lossless format, still popular for simple animations 2. Joint Photographic Experts Group (JPEG or JPG): Most popular lossy image compression format 3. Portable Network Graphics (PNG): Most popular lossless image compression format

Select three characteristics of a traditional hard drive.

1. Has a read/write head to detect magnetic charges 2. Has physically spinning platters 3. Uses magnetic charges to store data

Select the characteristics of a Blu-ray disc.

1. Holds approximately 50 GB of data 2. Uses pits and lands to store data

Match the following regarding file compression.

1. Lossless: Reduces space required by reducing redundancy within files 2. Lossy: Reduces space required by removing less valuable data 3. Zip: A lossless compression format

Select three storage devices.

1. Optical drives 2. USB drives 3. External hard drives

You own a pet care center. What fields might you enter when you create a table for dogs that you care for?

1. Owner's last name 2. Pet's name 3. Owner's address

Select two image compression formats.

1. PNG 2. JPEG

Select two reasons to compress a file.

1. Reduce bandwidth needed to transmit a file 2. Reduce storage space requirements

Select two advantages of using cloud storage.

1. Redundancy—data is stored on multiple servers. 2. Availability—data can be retrieved by any Internet-connected device.

Select three methods of using cloud storage.

1. Saving a photo on Flickr 2. Purchasing online storage space 3. E-mailing a file to yourself

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

1. Student number 2. Social Security Number

Match the capacity with the storage device.

1. Typical laptop: 500 GB-1 TB 2. DVD: 3-5 GB 3. Typical tablet or smartphone: 16-256 GB

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

1. USB drive has shorter access time. 2. USB drive is more durable.

Select three characteristics of cloud storage.

1. Users can download files to other devices on the Internet. 2. Files are backed-up (stored on multiple servers). 3. Servers act like giant hard drives.

Select two characteristics of a traditional hard drive.

1. Uses magnetically charged plates to store data 2. Often found in desktop computers

Select three characteristics of SSD storage.

1. Uses the same technology that is found in USB drives 2. Has no mechanically moving parts 3. Uses flash technology

The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data?

1. What field name will the data fall under 2. What data type will be included

Match the following regarding file compression.

1. Zip: A lossless compression format 2. Lossy: Reduces space required by removing less valuable data 3. Lossless: Reduces space required by reducing redundancy within files

Select the characteristics of a OneDrive account.

1. requires a Microsoft E-mail account 2. provides free cloud storage 3. can serve as extra storage space

Blu-rays provide approximately ________ of storage space.

50 GB

A typical laptop has a storage capacity of approximately ________.

500 GB-1 TB

CDs provide approximately ________ of data storage space.

700 MB

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

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ________ subsystem.

Data Administration

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

Data type

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

F2

The two most common audio file formats are WAV and ________.

MP4

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ________ System.

Management

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

RAID

The type of database that uses common fields to create links between tables is called a ________ database.

Relational

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

SSDs

One type of storage device is a ________.

USB drive

To change the size of your folder's icon, just right-click on a blank area of the Contents pane and click ________.

View

One emerging data storage challenge is the incredible amount of video being uploaded to ________.

YouTube

CDs store data using ________.

a reflective coating that has pits and lands

DVDs store data using ________.

a reflective coating that has pits and lands

When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ________ generation subsystem.

application

The smallest unit of data storage is a ________.

bit

One character of information, for example, a letter or a number comprises of one ________ of storage.

byte

To select a folder, simply put your cursor on it and ________.

click

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

E-mailing a file to yourself is an example of using ________ storage.

cloud

The fact that data on servers is nearly always backed up onto other servers gives ________ storage a major advantage over other data storage methods.

cloud

Large databases, often called data banks, that cover particular subjects are referred to as ________ databases.

commercial

A disadvantage of cloud storage is that ________.

data is only available when you are online

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ________.

database

Because it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a ________ has many advantages over a traditional filing system.

database

You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ________.

database

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ________.

databases

An integral part of a database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ________.

dictionary

A database that stores data in different physical locations and that users access though client/server networks is called a ________ database.

distributed

When you ________ a file Windows should automatically open it. If it can't Windows will prompt you to select the correct app to open the file.

double-click

The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS ________.

engine

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

field

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ________ key.

foreign

When you need to link two 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

To control how information is entered into a database, programmers and database administrators create ________ to help ensure data integrity.

forms

The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ________ subsystem.

generation

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

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

A refracted laser beam striking a photoreceptor from many different angles allows ________ storage to retain many bits of data in the same location.

holographic

Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ________.

integrity

Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.

integrity

The reliability and the accuracy of the information in a database is referred to as data ________.

integrity

A short (simple text) e-mail uses about one ________ of data.

kilobyte

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

logical

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

longer

Most desktop computers use ________ to store data.

magnetic hard drives

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem.

manipulation

The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms is referred to as the data ________ subsystem.

manipulation / maintenance

Because of its potential to diagnose health issues, one of the largest data requirements of the future will likely be ________.

mapping patients' genomes

A million bytes of data equals one ________.

megabyte

One thousand kilobytes (KB) equals one ________.

megabyte

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

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ________ database.

multidimensional

Server banks have capacities measured in ________.

petabytes

Blu-ray technology stores data using ________.

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

In a relational database, an important field that contains a unique value that identifies each record as individual is the ________ key.

primary

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ________.

query

To search a database for information, create a ________.

query

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ________.

record

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ________.

record

With regard to digital storage, RAID stands for ________.

redundant array of independent discs

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

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

shorter

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

storage

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

table