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