CGS 2060 Final

Common video file formats

- .mov -.avi

Advantages of using a database instead of a traditional filing system

- A database can hold longer amounts of data - A database can provide better data integrity

Video file compression formats

- AVI -MP4 -QuickTime

Devices manufactured by Samsung

- Galaxy - Note

Characteristics of a DVD

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

Of you own a small business, what can you do to ensure your computers and data is kept secure?

- keep software updated, particularly antivirus software - physically secure computers to minimize risk of theft - backup your data regularly

When choosing a cell phone provider, factors to consider include

- network size/ coverage - service/speed -pricing

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

Storage devices

- optical drive -external hard drive - USB drives

Advantages of helium drives over traditional hard drives

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

Reasons for compressing a file

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

Characteristics of a OneDrive account

- requires a Microsoft Email account - provides free cloud storage -can serve as extra storage space

Characteristics of computer storage

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

Methods of using cloud storage

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

Object-oriented databses

- store instructions for how to compute the data as well as the data to be processed - equipped to handle unstructured data such as MP4 files, video, images, and extremely large files - use object query language to construct queries that extract data from the database

Commonly used names for USB drives

- thumb drives - flash drives

Characteristics of cloud storage

- users can download files to other devices on the internet - files are backed-up (stored on multiple servers) - servers act like giant hard drives

Characteristics of SSD storage

- uses flash technology - uses the same technology that is found in USB drives - has no mechanically moving parts

Characteristics of a traditional hard drive

- uses magnetic charges to store data -has a read/write head to detect magnetic charges - has physically moving platters

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

- what field name will the data fall under - what data type will be included

Optical drives

-Blu-ray player - DVD drive

Advantages of using a USB drive instead of a DVD

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

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

-a transistor - a hole in a punch card

Which of these extensions, if you open it, will probably install software onto your computer?

.exe

file extension used for drawings

.gif

Capacity of a DVD

3-5 GB

Samsung smartphone

Galaxy s6

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

RAID

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

SSDs

The mobile switching station can connect calls to mobile switching station belonging to other cellular networks

True

Zip

a lossless compression format

The smallest unit of data is a ____

bit

Intrusion Detection Systems use several techniques to protect networks. One is called a "halt", which stops the hacker from progressing into the network. Another is called a ______, which closes the access point used by the hacker

block

One character of information, for example, a letter or a number consists of one ____ of storage

byte

Server banks have capacities measured in

petabytes

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

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

Image compression formats

- JPEG -PNG

Advantages of cloud storage

- Redundancy - Availability

Several ways to create a new folder in Windows

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

Usual tasks of information systems program managers

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

Audio file compression formats

- WAV -MP4

What's true about database fields

- a group of related characters in a database -Represent a characteristics of someone or something -Primary key is a field designation

When reporting ethics violations of a co-worker to your employer, it's important to ______

- be brief and direct -state only what you witnessed

Usual tasks of a data analyst

- collects data -interprets information provided by the database - creates reports for senior management

Characteristics of solid state drive storage devices

- durable, no moving mechanical parts - uses electronic circuits to store data

Capacity of a typical tablet

16-256 GB

Capacity of a typical laptop

500 GB- 1 TB

A tablet is generally understood to have a screen size of at least ____ inches

7

CDs provide approximately _____ of data storage space

700 MB

Business owners, copyright holders, and network administrators publish _____ so that users understand what is expected and permissible when they use the network, computer equipment, and/or software

AUPs

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

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 quick way to rename files or folders in Windows is to select the item and then press the _____ key

F2

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

Field

Amazon offers 2 lines of tablet computers, the Amazon Fire and the Amazon Fire _______

HDX

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

Hierarchy

A link between tables in a relational database that defines how the data is related is called a

Relationship

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

Being able to surf the web, watch videos, and listen to streaming audio is why cell service with a _____ plan is extremely popular in the U.S.

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

A database that stores data in different physical locations and that users access through 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 to correct app to open the file

double-click

Solid state drives store data using ______

electronic circuits

To control how information is entered into a database, programmers and database administrator create ______ to help ensure data integrity

forms

A desktop computer's RAM is measured in?

gigabytes

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

helium

Third party apps must be reviewed and approved by Apple before being available for the

iOS

Apple's mobile device with the largest display is the

iPad Pro

The role of installing, maintaining, repairing and replacing information system hardware and software typically falls to the ______

information systems technician

Adam was in 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

A short email uses about one ______ of data

kilobyte

Image compression format of GIF

legacy (outdated) lossless format

Because a metal platter is physically spinning, hard drives have ______ access time than solid state hard drives

longer

Most desktop computers use _____ to store data

magnetic hard drives

Be careful to ony open email from senders you know and trust. ________ may be contained in email messages

malware

One of the largest data requirements of the future will likely be _____

mapping patients' genomes

A million bytes of data equals approximately 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 ______

memristor

Image compression format of PNG

most popular lossless image compression format

Image compression format of JPEG or JPG

most popular lossy image compression format

Storage device that uses lasers to read CDs, DVDs, or Blu- ray discs is referred to as an _____

optical drive

Blu-ray stores data using

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

In a database, a row of information is called a _____

record

Lossless

reduces space required by reducing redundancy within files

Lossy

reduces space required by removing less valuable data

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

relational

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

remote desktop

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

reports

The most common method of renaming files and folders is to simple _____ on the item and select Rename

right-click

If you're in an area where your home network has no cell coverage, you may need to use the cellular network of a different provider. This is called ______

roaming

The two major concerns regarding cloud storage are reliability and _______

security

In general, the _____ the access time, the faster the hard drive

shorter

The small computer within your phone that enhances the sound quality of your call is called a digital ______ processor

signal

While not a required step in sending an email, it's wise to _____ any message before clicking send

spell check

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

storage

The cell tower's base transmission station is connected to a mobile _____ station

switching

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

table

A thousand gigabytes equals one _____

terabyte

In urban areas, the cell towers become more numerous and the cell signals transmitted by the cell towers are ______, than those in less populate areas

weaker